PG_USER_MAPPINGS

PG_USER_MAPPINGS displays user mapping information.

This is essentially a publicly readable view of PG_USER_MAPPING that leaves out the options column if the user has no rights to use the system catalog and query the view. Common users must be authorized to access this view.

**Table 1** PG_USER_MAPPINGS columns
Name	Type	Reference	Description
umid	oid	oid in PG_USER_MAPPING	OID of the user mapping.
srvid	oid	oid in PG_FOREIGN_SERVER	OID of the foreign server that contains the mapping.
srvname	name	srvname in PG_FOREIGN_SERVER	Name of the foreign server.
umuser	oid	oid in PG_AUTHID	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. If the current user is the owner of the foreign server, the value is keyword=value strings. Otherwise, the value is NULL.