52.9. pg_auth_members — PostgreSQL 11

Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / 20devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1

Historical version. PostgreSQL 11 has reached end of support. 2023-11-09. See the current manual.

52.9. `pg_auth_members`
Prev	Up	Chapter 52. System Catalogs	Home	Next

52.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 52.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
52.8. `pg_authid`	Home	52.10. `pg_cast`

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.