rembThe 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.
Table 53.21. pg_roles Columns
| Column Type
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.9 for more information.
| |
rolconfig text[]
Role-specific defaults for run-time configuration variables
| |
oid oid (references pg_authid.oid)
ID of role
|