↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

System Catalogs / System catalogs

pg_init_privs

Read the PG 18 manual

The catalog pg_init_privs records information about the initial privileges of objects in the system.

Reading PG 18current·documented in 12 of 24 versions, 9.6 to 20

Kind
System catalogs
Columns in this snapshot
5
Definition source
English manual
Metadata snapshot
18.6

Columns 5

As listed in the PostgreSQL 18 manual.

ColumnTypeDescription / reference
objoidoidNOT NULLThe OID of the specific object
classoidoidNOT NULLThe OID of the system catalog the object is in
pg_class.oid
objsubidint4NOT NULLFor a table column, this is the column number (the objoid and classoid refer to the table itself). For all other object types, this column is zero.
privtypecharNOT NULLA code defining the type of initial privilege of this object; see text
initprivsaclitem[]NOT NULLThe initial access privileges; see Section 5.8 for details
Column history across versions
Version history 4
  1. 18 → 19 reworded
  2. 16 → 17 reworded
  3. 11 → 12 reworded
  4. 9.5 → 9.6 added

Definition snapshot: english-manuals:903db91f7600be047cb5a67709c… · English manual source