50.72. pg_roles

The view pg_roles provides access to information about database roles. This is simply a publicly readable view of pg_authid that blanks out the password field.

This view explicitly exposes the OID column of the underlying table, since that is needed to do joins to other catalogs.

Table 50-73. pg_roles Columns

Name	Type	References	Description
`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.7 for more information.
`rolconfig`	`text[]`		Role-specific defaults for run-time configuration variables
`oid`	`oid`	`pg_authid.oid`	ID of role

Prev		Next
`pg_replication_slots`	Up	`pg_rules`

© 1996–2019 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.
https://www.postgresql.org/docs/9.6/view-pg-roles.html