PG_USER_MAPPING

PG_USER_MAPPING records mappings from local users to remote.

This system catalog is accessible only to system administrators. 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	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 the current mapping.
umoptions	text[]	-	User mapping specific options, expressed in a string in the format of keyword=value

Parent topic: User and Permission Management

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

The system is busy. Please try again later.