PG_USER_MAPPING

PG_USER_MAPPING records the mappings from local users to remote.

It is accessible only to users with system administrator rights. You can use view PG_USER_MAPPINGS to query common users.

**Table 1** PG_USER_MAPPING columns
Column	Type	Reference	Description
OID	OID	-	Row identifier (hidden attribute; must be explicitly selected)
umuser	OID	PG_AUTHID.oid	OID of the local role being mapped, 0 if the user mapping is public
umserver	OID	PG_FOREIGN_SERVER.oid	OID of the foreign server that contains this mapping
umoptions	Text[]	-	Option used for user mapping. It is a keyword=value string.

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

The system is busy. Please try again later.