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.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- view
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- umid, srvid, srvname, umuser, usename, umoptions
- runtime verified
- false
- source
- english-manual
Definition PG 18
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.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| umid | oid | Nullable | OID of the user mapping |
| srvid | oid | Nullable | The OID of the foreign server that contains this mapping |
| srvname | name | Nullable | Name of the foreign server |
| umuser | oid | Nullable | OID of the local role being mapped, or zero if the user mapping is public |
| usename | name | Nullable | Name of the local user to be mapped |
| umoptions | text[] | Nullable | User mapping specific options, as “keyword=value” strings |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:823b037b1da7a91b1bb8d9d2f4af204f9e7d337278ee7a0abd31d36d53214bb0
Text language: en · catalog-bilingual-repair:823b037b1da7a91b1bb8d9d2f4af204f9e7d337278ee7a0abd31d36d53214bb0