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

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.

Parent topic: System Catalogs Definitions

check-circle-line exclamation-circle-line close-line
Scroll to top icon