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

SYSTEM CATALOGS / SYSTEM CATALOGS

pg_authid

Read PG 18 manual ↗

The catalog pg_authid contains information about database authorization identifiers (roles).

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

Columns 12

Column	Type	Description / reference
`oid`	`oid`	Row identifier
`rolname`	`name`	Role name
`rolsuper`	`bool`	Role has superuser privileges
`rolinherit`	`bool`	Role automatically inherits privileges of roles it is a member of
`rolcreaterole`	`bool`	Role can create more roles
`rolcreatedb`	`bool`	Role can create databases
`rolcanlogin`	`bool`	Role can log in. That is, this role can be given as the initial session authorization identifier.
`rolreplication`	`bool`	Role is a replication role. A replication role can initiate replication connections and create and drop replication slots.
`rolbypassrls`	`bool`	Role bypasses every row-level security policy, see Section 5.9 for more information.
`rolconnlimit`	`int4`	For roles that can log in, this sets maximum number of concurrent connections this role can make. -1 means no limit.
`rolpassword`	`text`	Encrypted password; null if none. The format depends on the form of encryption used.
`rolvaliduntil`	`timestamptz`	Password expiry time (only used for password authentication); null if no expiration

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
`oid`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`rolname`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`rolsuper`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`rolinherit`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`rolcreaterole`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`rolcreatedb`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`rolcanlogin`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`rolreplication`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`rolbypassrls`	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●
`rolconnlimit`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`rolpassword`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`rolvaliduntil`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`rolcatupdate`	●	●	●	●	●	·	·	·	·	·	·	·	·	·	·	·	·	·

Version history 10

Definition snapshot: english-manuals:c7a68c8dae4cc0683ede9ab9f65… · English manual source