PG_USER_MAPPINGS

Updated on 2023-10-31 GMT+08:00

View PDF

PG_USER_MAPPINGS displays information about user mappings.

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 it.

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