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