The pg_user_mapping catalog stores user-mapping-specific connection information used to access foreign servers.
| Column name | Data type | Description |
|---|---|---|
oid |
oid |
A row identifier. |
umuser |
oid (references pg_authid.oid) |
The OID of the local role being mapped. 0 – Public user mapping. |
umserver |
oid (references pg_foreign_server.oid) |
The OID of the foreign server that contains this mapping. |
umoptions |
text[] |
Options specific to the user mapping, expressed as “keyword=value” strings. |