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

SYSTEM CATALOGS / SYSTEM VIEWS

pg_roles

Read PG 18 manual ↗

The view pg_roles provides access to information about database roles.

Kind: System views
Columns in this snapshot: 13
Definition source: English manual

Columns 13

Column	Type	Description / reference
`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.
`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`	Not the password (always reads as ********)
`rolvaliduntil`	`timestamptz`	Password expiry time (only used for password authentication); null if no expiration
`rolbypassrls`	`bool`	Role bypasses every row-level security policy, see Section 5.9 for more information.
`rolconfig`	`text[]`	Role-specific defaults for run-time configuration variables
`oid`	`oid`	ID of role pg_authid.oid

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

Version history 7

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