pg_auth_members — PostgreSQL system catalog

The PostgreSQL pg_auth_members system catalog: full column reference (names, types, descriptions), catalog relationships and version support.

The Sev-1 Admin
The Sev-1 Admin  ·  1 min read

Summary

The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed.

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_auth_members system catalog exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

  • oid oid
    Row identifier
  • roleid oid references pg_authid.oid
    ID of a role that has a member
  • member oid references pg_authid.oid
    ID of a role that is a member of roleid
  • grantor oid references pg_authid.oid
    ID of the role that granted this membership
  • admin_option bool
    True if member can grant membership in roleid to others
  • inherit_option bool
    True if the member automatically inherits the privileges of the granted role
  • set_option bool
    True if the member can SET ROLE to the granted role

Related catalogs

This object references the following other system catalogs:

Version applicability

Present in PostgreSQL 17, 18, 19 (verified against each release’s documentation). This is a long-standing system object that also exists in earlier PostgreSQL releases.

Related & references

Reference: PostgreSQL documentation — pg_auth_members.