PostgreSQL 19 ← 18
← Catalog atlas / pg_user
SYSTEM VIEW · System view
pg_user
The view pg_user provides access to information about database users. This is simply a publicly readable view of pg_shadow that blanks out the password field.
Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗
Columns PostgreSQL 18
pg_userPostgreSQL 19 beta 3 is a preview snapshot; the structure can still change before release.
| COLUMN | TYPE | DESCRIPTION |
|---|---|---|
usename |
name |
User name |
usesysid |
oid |
ID of this user |
usecreatedb |
booleanDocumented as:bool |
User can create databases |
usesuper |
booleanDocumented as:bool |
User is a superuser |
userepl |
booleanDocumented as:bool |
User can initiate streaming replication and put the system in and out of backup mode. |
usebypassrls |
booleanDocumented as:bool |
User bypasses every row-level security policy, see Section 5.9 for more information. |
passwd |
text |
Not the password (always reads as ********) |
valuntil |
timestamp with time zoneDocumented as:timestamptz |
Password expiry time (only used for password authentication) |
useconfig |
text[] |
Session defaults for run-time configuration variables |
Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.
Common system columns 0
System attributes PostgreSQL provides, normally not expanded by SELECT *. Kept separately so they are not mixed in with ordinary columns.
| Columns | Type | attnum |
|---|
Column evolution matrix
Hover a cell for the column typePresentAdded / type or attribute changeRemoved
| COLUMN | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
usename |
|||||||||||||||||
usesysid |
|||||||||||||||||
usecreatedb |
|||||||||||||||||
usesuper |
|||||||||||||||||
usecatupd |
− | – | – | – | – | – | – | – | – | – | – | – | |||||
passwd |
|||||||||||||||||
valuntil |
|||||||||||||||||
useconfig |
|||||||||||||||||
userepl |
– | ||||||||||||||||
usebypassrls |
– | – | – | – | – |
9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.
Evolution timeline
Changes between adjacent majorsPostgreSQL 17 ← 16
PostgreSQL 14 ← 13
PostgreSQL 12 ← 11
PostgreSQL 9.5 ← 9.4
PostgreSQL 9.2 ← 9.1
PostgreSQL 9.1 ← 9.0
Compare any two versions
Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.