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.

columntypereferencesdescription
umuseroidpg_authid.oidOID of the local role being mapped, 0 if the user mapping is public
umserveroidpg_foreign_server.oidThe OID of the foreign server that contains this mapping
umoptionstext
[ ]
 User mapping specific options, as “keyword=value” strings.

Parent topic: System Catalogs Definitions