System Catalogs / System views
pg_user_mappings
Read the PG 18 manualThe view pg_user_mappings provides access to information about user mappings.
Reading PG 18current·documented in 19 of 24 versions, 8.4 to 20
- Kind
- System views
- Columns in this snapshot
- 6
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 6
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
umid | oid | OID of the user mapping pg_user_mapping.oid |
srvid | oid | The OID of the foreign server that contains this mapping pg_foreign_server.oid |
srvname | name | Name of the foreign server pg_foreign_server.srvname |
umuser | oid | OID of the local role being mapped, or zero if the user mapping is public pg_authid.oid |
usename | name | Name of the local user to be mapped |
umoptions | text[] | User mapping specific options, as “keyword=value” strings |
Column history across versions
Version history 5
Definition snapshot: english-manuals:930730db370c8890c02b90b4e69… · English manual source