PostgreSQL 16 ← 15
← Catalog atlas / pg_auth_members
SYSTEM CATALOG · System catalog
pg_auth_members
The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed. Because user identities are cluster-wide, pg_auth_members is shared across all databases of a cluster: there is only one copy of pg_auth_members per cluster, not one per database.
Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗
Columns PostgreSQL 18
pg_auth_membersPostgreSQL 19 beta 3 is a preview snapshot; the structure can still change before release.
| COLUMN | TYPE | DESCRIPTION |
|---|---|---|
oid |
oidNOT NULL |
Row identifier |
roleid |
oidNOT NULL |
ID of a role that has a memberReferences:pg_authid.oid |
member |
oidNOT NULL |
ID of a role that is a member of roleidReferences:pg_authid.oid |
grantor |
oidNOT NULL |
ID of the role that granted this membershipReferences:pg_authid.oid |
admin_option |
booleanNOT NULLDocumented as:bool |
True if member can grant membership in roleid to others |
inherit_option |
booleanNOT NULLDocumented as:bool |
True if the member automatically inherits the privileges of the granted role |
set_option |
booleanNOT NULLDocumented as:bool |
True if the member can SET ROLE to the granted role |
Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.
Common system columns 6
System attributes PostgreSQL provides, normally not expanded by SELECT *. Kept separately so they are not mixed in with ordinary columns.
| Columns | Type | attnum |
|---|---|---|
tableoid | oid | -6 |
cmax | cid | -5 |
xmax | xid | -4 |
cmin | cid | -3 |
xmin | xid | -2 |
ctid | tid | -1 |
Column evolution matrix
Hover a cell for the column typePresentAdded / type or attribute changeRemoved
| COLUMN | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
roleid |
|||||||||||||||||
member |
|||||||||||||||||
grantor |
|||||||||||||||||
admin_option |
|||||||||||||||||
oid |
– | – | – | – | – | – | – | – | – | – | – | – | – | ||||
inherit_option |
– | – | – | – | – | – | – | – | – | – | – | – | – | ||||
set_option |
– | – | – | – | – | – | – | – | – | – | – | – | – |
9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.
Evolution timeline
Changes between adjacent majorsCompare any two versions
Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.