System Catalogs / System catalogs
pg_auth_members
Read the PG 18 manualThe catalog pg_auth_members shows the membership relations between roles.
Reading PG 18current·documented in 22 of 24 versions, 8.1 to 20
- Kind
- System catalogs
- Columns in this snapshot
- 7
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 7
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
oid | oidNOT NULL | Row identifier |
roleid | oidNOT NULL | ID of a role that has a member pg_authid.oid |
member | oidNOT NULL | ID of a role that is a member of roleid pg_authid.oid |
grantor | oidNOT NULL | ID of the role that granted this membership pg_authid.oid |
admin_option | boolNOT NULL | True if member can grant membership in roleid to others |
inherit_option | boolNOT NULL | True if the member automatically inherits the privileges of the granted role |
set_option | boolNOT NULL | True if the member can SET ROLE to the granted role |
Column history across versions
Definition snapshot: english-manuals:651a007f00d2521d9876eb03a39… · English manual source