The pg_authid catalog provides information about database authorization identifiers (roles).
| Column name | Data type | Description |
|---|---|---|
oid |
oid |
A row identifier. |
rolname |
name |
A role name. |
rolsuper |
bool |
The role has superuser privileges. |
rolinherit |
bool |
The role automatically inherits privileges from its parent roles. |
rolcreaterole |
bool |
The role can create other roles. |
rolcreatedb |
bool |
The role can create databases. |
rolcanlogin |
bool |
The role can log in (used as a session authorization identifier). |
rolreplication |
bool |
The role is a replication role that can initiate replication connections and manage replication slots. |
rolbypassrls |
bool |
The role bypasses all row-level security policies. |
rolconnlimit |
int4 |
The maximum number of concurrent connections for this role. -1 – No limit. |
rolpassword |
text |
An encrypted password. NULL – No password is set. |
rolvaliduntil |
timestamptz |
The password expiry time. NULL – No password expiration. |