pg_init_privs
pg_init_privs
is a system catalogue table containing information about the initial privileges of objects.
The purpose behind this table is to enable applications (e.g. pg_dump
) to detect when privileges have changed from the default and act accordingly (e.g. by explicitly inserting privilege commands in the dumped DDL SQL).
pg_init_privs
was added in PostgreSQL 9.6.
Definition by PostgreSQL version
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)
Documentation: 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)
Documentation: 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)
Documentation: 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)
Documentation: 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)
Documentation: 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)
Documentation: 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)
Documentation: pg_init_privs
Change history
This table has not changed since it was added in PostgreSQL 9.6.
- PostgreSQL 9.6
- added (commit 6c268df1)
References
- PostgreSQL documentation: pg_init_privs