PostgreSQL

53.65. `pg_user_mapping`
Prev	Up	Chapter 53. System Catalogs	Home	Next

53.65. `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 53.66. pg_user_mapping Columns

Column Type Description

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 “[.quote]#keyword=value”# strings

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 “[.quote]#keyword=value”# strings

Prev	Up	Next
53.64. `pg_type`	Home	Chapter 54. System Views

53.64. pg_type

Home

Chapter 54. System Views

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

PostgreSQL

53.65. pg_user_mapping #

Submit correction

53.65. `pg_user_mapping` #