pg_default_acl
The catalog pg_default_acl stores initial privileges to be assigned to newly created objects.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- catalog
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- oid, defaclrole, defaclnamespace, defaclobjtype, defaclacl
- runtime verified
- false
- source
- english-manual
Definition PG 18
The catalog pg_default_acl stores initial privileges to be assigned to newly created objects.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| oid | oid | Not null | Row identifier |
| defaclrole | oid | Not null | The OID of the role associated with this entry |
| defaclnamespace | oid | Not null | The OID of the namespace associated with this entry, or zero if none |
| defaclobjtype | char | Not 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 |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:8852f80ec8622f60acfbd97e35657ca39dbc859a4d8b05d9300a5edf72e68578
Text language: en · catalog-bilingual-repair:8852f80ec8622f60acfbd97e35657ca39dbc859a4d8b05d9300a5edf72e68578