51.63. pg_user_mapping

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

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

Prev	Up	Next
51.62. `pg_type`	Home	51.64. System Views