pg_user_mappings — PostgreSQL system view

The PostgreSQL pg_user_mappings system view: full column reference (names, types, descriptions), catalog relationships and version support.

The Sev-1 Admin
The Sev-1 Admin  ·  2 min read

Summary

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.

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_user_mappings system view exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

  • umid oid references pg_user_mapping.oid
    OID of the user mapping
  • srvid oid references pg_foreign_server.oid
    The OID of the foreign server that contains this mapping
  • srvname name references pg_foreign_server.srvname
    Name of the foreign server
  • umuser oid references pg_authid.oid
    OID of the local role being mapped, or zero 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

Related catalogs

This object references the following other system catalogs:

Version applicability

Present in PostgreSQL 17, 18, 19 (verified against each release’s documentation). This is a long-standing system object that also exists in earlier PostgreSQL releases.

Related & references

Reference: PostgreSQL documentation — pg_user_mappings.