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.
|Role has superuser privileges
|Role automatically inherits privileges of roles it is a member of
|Role can create more roles
|Role can create databases
|Role can log in. That is, this role can be given as the initial session authorization identifier
|Role is a replication role. A replication role can initiate replication connections and create and drop replication slots.
|For roles that can log in, this sets maximum number of concurrent connections this role can make. -1 means no limit.
|Not the password (always reads as
|Password expiry time (only used for password authentication); null if no expiration
|Role bypasses every row level security policy, see Section 5.7 for more information.
|Role-specific defaults for run-time configuration variables
|ID of role