PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM CATALOGS

pg_auth_members

Read PG 18 manual ↗

The catalog pg_auth_members shows the membership relations between roles.

Kind: System catalogs
Columns in this snapshot: 7
Definition source: English manual

Columns 7

Column	Type	Description / reference
`oid`	`oid`	Row identifier
`roleid`	`oid`	ID of a role that has a member pg_authid.oid
`member`	`oid`	ID of a role that is a member of roleid pg_authid.oid
`grantor`	`oid`	ID of the role that granted this membership pg_authid.oid
`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

Column history across versions

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	20
`roleid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`member`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`grantor`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`admin_option`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`oid`	·	·	·	·	·	·	·	·	·	·	·	·	·	●	●	●	●	●
`inherit_option`	·	·	·	·	·	·	·	·	·	·	·	·	·	●	●	●	●	●
`set_option`	·	·	·	·	·	·	·	·	·	·	·	·	·	●	●	●	●	●

Version history 1

PG 15 → 16changed

Definition snapshot: english-manuals:7260dc1ee04298433a0fe4cd2b6… · English manual source