PostgreSQL 14 ← 13
← Catalog atlas / pg_user_mappings
SYSTEM VIEW · System view
pg_user_mappings
The view pg_user_mappings provides access to information about user mappings. This is essentially a publicly readable view of pg_user_mapping that leaves out the options field if the user has no rights to use it.
Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗
Columns PostgreSQL 18
pg_user_mappingsPostgreSQL 19 beta 3 is a preview snapshot; the structure can still change before release.
| COLUMN | TYPE | DESCRIPTION |
|---|---|---|
umid |
oid |
OID of the user mappingReferences:pg_user_mapping.oid |
srvid |
oid |
The OID of the foreign server that contains this mappingReferences:pg_foreign_server.oid |
srvname |
name |
Name of the foreign serverReferences:pg_foreign_server.srvname |
umuser |
oid |
OID of the local role being mapped, or zero if the user mapping is publicReferences:pg_authid.oid |
usename |
name |
Name of the local user to be mapped |
umoptions |
text[] |
User mapping specific options, as “keyword=value” strings |
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
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 10 ← 9.6
PostgreSQL 9.2 ← 9.1
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.