System Catalogs / System catalogs
pg_authid
Read the PG 18 manualThe catalog pg_authid contains information about database authorization identifiers (roles).
Reading PG 18current·documented in 22 of 24 versions, 8.1 to 20
- Kind
- System catalogs
- Columns in this snapshot
- 12
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 12
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
oid | oidNOT NULL | Row identifier |
rolname | nameNOT NULL | Role name |
rolsuper | boolNOT NULL | Role has superuser privileges |
rolinherit | boolNOT NULL | Role automatically inherits privileges of roles it is a member of |
rolcreaterole | boolNOT NULL | Role can create more roles |
rolcreatedb | boolNOT NULL | Role can create databases |
rolcanlogin | boolNOT NULL | Role can log in. That is, this role can be given as the initial session authorization identifier. |
rolreplication | boolNOT NULL | Role is a replication role. A replication role can initiate replication connections and create and drop replication slots. |
rolbypassrls | boolNOT NULL | Role bypasses every row-level security policy, see Section 5.9 for more information. |
rolconnlimit | int4NOT NULL | For roles that can log in, this sets maximum number of concurrent connections this role can make. -1 means no limit. |
rolpassword | text | Encrypted password; null if none. The format depends on the form of encryption used. |
rolvaliduntil | timestamptz | Password expiry time (only used for password authentication); null if no expiration |
Column history across versions
Version history 14
Definition snapshot: english-manuals:94044086a436950d19e247c1dba… · English manual source