PG_USER_MAPPING

PG_USER_MAPPING records mappings from local users to remote.

This system catalog is accessible only to users with the SYSADMIN permission. Common users can query the PG_USER_MAPPINGS view.

**Table 1** PG_USER_MAPPING columns
Name	Type	Reference	Description
oid	oid	-	Row identifier (hidden attribute, which must be specified)
umuser	oid	oid in PG_AUTHID	OID of the local role being mapped (0 if the user mapping is public)
umserver	oid	oid in PG_FOREIGN_SERVER	OID of the foreign server that contains the mapping
umoptions	text[]	-	User mapping specific options, expressed in a string in the format of keyword=value

Parent topic:System Catalogs

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.