8th February 2024: PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 Released!
Supported Versions: Current (16) / 15 / 14 / 13 / 12
Development Versions: devel
Unsupported versions: 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1
51.9. pg_auth_members
Prev  Up Chapter 51. System Catalogs Home  Next

51.9. 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.

Table 51.9. pg_auth_members Columns

Name Type References Description
roleid oid pg_authid.oid ID of a role that has a member
member oid pg_authid.oid ID of a role that is a member of roleid
grantor oid pg_authid.oid ID of the role that granted this membership
admin_option bool   True if member can grant membership in roleid to others

Prev  Up  Next
51.8. pg_authid  Home  51.10. pg_cast

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.