System Catalogs / System views
pg_roles
Read the PG 18 manualThe view pg_roles provides access to information about database roles.
Reading PG 18current·documented in 22 of 24 versions, 8.1 to 20
- Kind
- System views
- Columns in this snapshot
- 13
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 13
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
rolname | name | Role name |
rolsuper | bool | Role has superuser privileges |
rolinherit | bool | Role automatically inherits privileges of roles it is a member of |
rolcreaterole | bool | Role can create more roles |
rolcreatedb | bool | Role can create databases |
rolcanlogin | bool | Role can log in. That is, this role can be given as the initial session authorization identifier |
rolreplication | bool | Role is a replication role. A replication role can initiate replication connections and create and drop replication slots. |
rolconnlimit | int4 | For roles that can log in, this sets maximum number of concurrent connections this role can make. -1 means no limit. |
rolpassword | text | Not the password (always reads as ********) |
rolvaliduntil | timestamptz | Password expiry time (only used for password authentication); null if no expiration |
rolbypassrls | bool | Role bypasses every row-level security policy, see Section 5.9 for more information. |
rolconfig | text[] | Role-specific defaults for run-time configuration variables |
oid | oid | ID of role pg_authid.oid |
Column history across versions
Version history 11
Definition snapshot: english-manuals:77717f087b36247c1a889f0b3de… · English manual source