pg_user_mapping

pg_user_mapping

The pg_user_mapping catalog table stores the mappings from local users to remote users. You must have administrator privileges to view this catalog.

Table 1. pg_catalog.pg_user_mapping
column type references description
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 The OID of the foreign server that contains this mapping
umoptions text [ ]   User mapping specific options, as "keyword=value" strings.