Skip to main content
Version: 2.x

pg_user_mapping

The system catalog table pg_user_mapping stores the mappings from local user to remote user. You must have administrator privileges to view this catalog. Access to this catalog is restricted from normal users, use the pg_user_mappings view instead.

columntypereferencesdescription
oidoidThe object ID
umuseroidpg_authid.oidOID of the local role being mapped, 0 if the user mapping is public.
umserveroidpg_foreign_server.oidOID of the foreign server that contains this mapping
umoptionsARRAY User mapping-specific options, as "keyword=value" strings.