September 26, 2024: PostgreSQL 17 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13 / 12
Development Versions: devel
Unsupported versions: 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4

51.94. pg_user_mappings

The view pg_user_mappings provides access to information about user mappings. This is essentially a publicly readable view of pg_user_mapping that leaves out the options field if the user has no rights to use it.

Table 51.95. pg_user_mappings Columns

Name Type References Description
umid oid pg_user_mapping.oid OID of the user mapping
srvid oid pg_foreign_server.oid The 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, as keyword=value strings

To protect password information stored as a user mapping option, the umoptions column will read as null unless one of the following applies:

  • current user is the user being mapped, and owns the server or holds USAGE privilege on it

  • current user is the server owner and mapping is for PUBLIC

  • current user is a superuser

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.