PostgreSQL

52.92. `pg_user_mappings`
Prev	Up	Chapter 52. System Catalogs	Home	Next

52.92. `pg_user_mappings`

The view pg_user_mappings provides access to information about user mappings. This is essentially a publicly readable view of pg_user_mapping that leaves out the options field if the user has no rights to use it.

Table 52.93. pg_user_mappings Columns

Name Type References Description

Name	Type	References	Description
`umid`	`oid`	`pg_user_mapping.oid`	OID of the user mapping
`srvid`	`oid`	`pg_foreign_server.oid`	The OID of the foreign server that contains this mapping
`srvname`	`name`	`pg_foreign_server.srvname`	Name of the foreign server
`umuser`	`oid`	`pg_authid.oid`	OID of the local role being mapped, 0 if the user mapping is public
`usename`	`name`		Name of the local user to be mapped
`umoptions`	`text[]`		User mapping specific options, as “[.quote]#keyword=value”# strings

umid

oid

pg_user_mapping.oid

OID of the user mapping

srvid

oid

pg_foreign_server.oid

The OID of the foreign server that contains this mapping

srvname

name

pg_foreign_server.srvname

Name of the foreign server

umuser

oid

pg_authid.oid

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

usename

name

Name of the local user to be mapped

umoptions

text[]

User mapping specific options, as “[.quote]#keyword=value”# strings

To protect password information stored as a user mapping option, the umoptions column will read as null unless one of the following applies:

current user is the user being mapped, and owns the server or holds USAGE privilege on it
current user is the server owner and mapping is for PUBLIC
current user is a superuser

Prev	Up	Next
52.91. `pg_user`	Home	52.93. `pg_views`

52.91. pg_user

Home

52.93. pg_views

PostgreSQL

52.92. pg_user_mappings

52.92. `pg_user_mappings`