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.
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, roleid, member, grantor, admin_option, inherit_option, set_option
- runtime verified
- false
- source
- english-manual
Definition PG 18
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.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| oid | oid | Not null | Row identifier |
| roleid | oid | Not null | ID of a role that has a member |
| member | oid | Not null | ID of a role that is a member of roleid |
| grantor | oid | Not null | ID of the role that granted this membership |
| admin_option | bool | Not null | True if member can grant membership in roleid to others |
| inherit_option | bool | Not null | True if the member automatically inherits the privileges of the granted role |
| set_option | bool | Not null | True if the member can SET ROLE to the granted role |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:885c49c059d688c75f88b07b5d1235dcd39815e0b6b6f8c10489ccf676e355b6
Text language: en · catalog-bilingual-repair:885c49c059d688c75f88b07b5d1235dcd39815e0b6b6f8c10489ccf676e355b6