55.66. pg_user

55.66. `pg_user_mapping`
Prev	Up	Chapter 55. System Catalogs	Home	Next

55.66. `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 55.67. pg_user_mapping Columns

Column Type Description
`oid` `oid` Row identifier
`umuser` `oid` (references `pg_authid`.`oid`) OID of the local role being mapped, or zero 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, or zero 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

55.66. pg_user_mapping

55.66. `pg_user_mapping`