System Catalogs / System catalogs
pg_default_acl
Read the PG 18 manualThe catalog pg_default_acl stores initial privileges to be assigned to newly created objects.
Reading PG 18current·documented in 18 of 24 versions, 9.0 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.
| Column | Type | Description / reference |
|---|---|---|
oid | oidNOT NULL | Row identifier |
defaclrole | oidNOT NULL | The OID of the role associated with this entry pg_authid.oid |
defaclnamespace | oidNOT NULL | The OID of the namespace associated with this entry, or zero if none pg_namespace.oid |
defaclobjtype | charNOT NULL | Type of object this entry is for: r = relation (table, view), S = sequence, f = function, T = type, n = schema, L = large object |
defaclacl | aclitem[]NOT NULL | Access privileges that this type of object should have on creation |
Column history across versions
Version history 6
Definition snapshot: english-manuals:6c239f76c629aa1d48c1daa206a… · English manual source