50.82. 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 50-83. pg_user_mappings Columns

NameTypeReferencesDescription
umidoidpg_user_mapping.oidOID of the user mapping
srvidoidpg_foreign_server.oid The OID of the foreign server that contains this mapping
srvnamenamepg_foreign_server.srvname Name of the foreign server
umuseroidpg_authid.oidOID of the local role being mapped, 0 if the user mapping is public
usenamename Name of the local user to be mapped
umoptionstext[]  User mapping specific options, as "keyword=value" strings. This column will show as null unless the current user is the user being mapped, or the mapping is for PUBLIC and the current user is the server owner, or the current user is a superuser. The intent is to protect password information stored as user mapping option.