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.
Table pg_roles Columns
| Column Type Description |
|---|
Role name |
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. |
Role-specific defaults for run-time configuration variables |
ID of role |