pg_init_privs

A system catalogue table containing information about the initial privileges of objects

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 (commit 6c268df1).

Definition by PostgreSQL version

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 first added.

Categories

System catalogue