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.
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.
The OID of the role's profile
Number of consecutive failed login attempts of a user. It is always
Status of the role:
The timestamp the role logged in last time
The timestamp of the role's first authentication failure
Not the password (always reads as
Password expiry time (only used for password authentication); null if no expiration
Password set time (only used for password authentication); null if password is not set.
Role bypasses every row-level security policy, see Section 5.8 for more information.
Role-specific defaults for run-time configuration variables
ID of role