PG_USER_MAPPINGS

PG_USER_MAPPINGS displays user mapping information. All users can view the report.

**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, it is a string in the format of "keyword=value". Otherwise, it is NULL.

Parent topic:System Views

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

The system is busy. Please try again later.