PostgreSQL 13 Documentation: 51.63. pg_user_mapping

51.63. `pg_user_mapping`
Prev	Up	Chapter 51. System Catalogs	Home	Next

51.63. `pg_user_mapping`

The catalog pg_user_mapping stores the mappings from local user to remote. Access to this catalog is restricted from normal users, use the view pg_user_mappings instead.

Table 51.64. pg_user_mapping Columns

Column Type Description
`oid` `oid` Row identifier
`umuser` `oid` (references `pg_authid`.`oid`) OID of the local role being mapped, 0 if the user mapping is public
`umserver` `oid` (references `pg_foreign_server`.`oid`) The OID of the foreign server that contains this mapping
`umoptions` `text[]` User mapping specific options, as “keyword=value” strings

Column Type

Description

oid oid

Row identifier

umuser oid (references pg_authid.oid)

OID of the local role being mapped, 0 if the user mapping is public

umserver oid (references pg_foreign_server.oid)

The OID of the foreign server that contains this mapping

umoptions text[]

User mapping specific options, as “keyword=value” strings