目录

pg_init_privs

包含有关对象初始权限的信息的系统表

pg_init_privs 是一个包含有关对象初始权限信息的系统目录表。

此表的目的是使应用程序（例如 pg_dump）能够检测权限何时从默认值更改并相应地采取措施（例如，通过在转储的 DDL SQL 中显式插入权限命令）。

pg_init_privs 在 PostgreSQL 9.6 中添加。

按 PostgreSQL 版本定义

pg_init_privs (PostgreSQL 17)

            Table "pg_catalog.pg_init_privs"
  Column   |   Type    | Collation | Nullable | Default 
-----------+-----------+-----------+----------+---------
 objoid    | oid       |           | not null | 
 classoid  | oid       |           | not null | 
 objsubid  | integer   |           | not null | 
 privtype  | "char"    |           | not null | 
 initprivs | aclitem[] |           | not null | 
Indexes:
    "pg_init_privs_o_c_o_index" PRIMARY KEY, btree (objoid, classoid, objsubid)

文档: pg_init_privs

pg_init_privs (PostgreSQL 16)

            Table "pg_catalog.pg_init_privs"
  Column   |   Type    | Collation | Nullable | Default 
-----------+-----------+-----------+----------+---------
 objoid    | oid       |           | not null | 
 classoid  | oid       |           | not null | 
 objsubid  | integer   |           | not null | 
 privtype  | "char"    |           | not null | 
 initprivs | aclitem[] |           | not null | 
Indexes:
    "pg_init_privs_o_c_o_index" PRIMARY KEY, btree (objoid, classoid, objsubid)

文档: pg_init_privs

pg_init_privs (PostgreSQL 15)

            Table "pg_catalog.pg_init_privs"
  Column   |   Type    | Collation | Nullable | Default 
-----------+-----------+-----------+----------+---------
 objoid    | oid       |           | not null | 
 classoid  | oid       |           | not null | 
 objsubid  | integer   |           | not null | 
 privtype  | "char"    |           | not null | 
 initprivs | aclitem[] |           | not null | 
Indexes:
    "pg_init_privs_o_c_o_index" PRIMARY KEY, btree (objoid, classoid, objsubid)

文档: pg_init_privs

pg_init_privs (PostgreSQL 14)

            Table "pg_catalog.pg_init_privs"
  Column   |   Type    | Collation | Nullable | Default 
-----------+-----------+-----------+----------+---------
 objoid    | oid       |           | not null | 
 classoid  | oid       |           | not null | 
 objsubid  | integer   |           | not null | 
 privtype  | "char"    |           | not null | 
 initprivs | aclitem[] |           | not null | 
Indexes:
    "pg_init_privs_o_c_o_index" PRIMARY KEY, btree (objoid, classoid, objsubid)

文档: pg_init_privs

pg_init_privs (PostgreSQL 13)

            Table "pg_catalog.pg_init_privs"
  Column   |   Type    | Collation | Nullable | Default 
-----------+-----------+-----------+----------+---------
 objoid    | oid       |           | not null | 
 classoid  | oid       |           | not null | 
 objsubid  | integer   |           | not null | 
 privtype  | "char"    |           | not null | 
 initprivs | aclitem[] |           | not null | 
Indexes:
    "pg_init_privs_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)

文档: pg_init_privs

pg_init_privs (PostgreSQL 12)

            Table "pg_catalog.pg_init_privs"
  Column   |   Type    | Collation | Nullable | Default 
-----------+-----------+-----------+----------+---------
 objoid    | oid       |           | not null | 
 classoid  | oid       |           | not null | 
 objsubid  | integer   |           | not null | 
 privtype  | "char"    |           | not null | 
 initprivs | aclitem[] |           | not null | 
Indexes:
    "pg_init_privs_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)

文档: pg_init_privs

pg_init_privs (PostgreSQL 11)

            Table "pg_catalog.pg_init_privs"
  Column   |   Type    | Collation | Nullable | Default 
-----------+-----------+-----------+----------+---------
 objoid    | oid       |           | not null | 
 classoid  | oid       |           | not null | 
 objsubid  | integer   |           | not null | 
 privtype  | "char"    |           | not null | 
 initprivs | aclitem[] |           | not null | 
Indexes:
    "pg_init_privs_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)

文档: pg_init_privs

pg_init_privs (PostgreSQL 10)

            Table "pg_catalog.pg_init_privs"
  Column   |   Type    | Collation | Nullable | Default 
-----------+-----------+-----------+----------+---------
 objoid    | oid       |           | not null | 
 classoid  | oid       |           | not null | 
 objsubid  | integer   |           | not null | 
 privtype  | "char"    |           | not null | 
 initprivs | aclitem[] |           | not null | 
Indexes:
    "pg_init_privs_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)

文档: pg_init_privs

pg_init_privs (PostgreSQL 9.6)

 Table "pg_catalog.pg_init_privs"
  Column   |   Type    | Modifiers 
-----------+-----------+-----------
 objoid    | oid       | not null
 classoid  | oid       | not null
 objsubid  | integer   | not null
 privtype  | "char"    | not null
 initprivs | aclitem[] | not null
Indexes:
    "pg_init_privs_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)

文档: pg_init_privs

更改历史记录

自 PostgreSQL 9.6 添加以来，此表一直没有更改。

类别

系统目录

反馈

提交对 "pg_init_privs" 的任何评论、建议或更正 此处.