Updated on 2025-07-22 GMT+08:00

PG_USER_MAPPING

PG_USER_MAPPING records the mappings from local users to remote.

It is accessible only to users with system administrator rights. You can use view PG_USER_MAPPINGS to query common users.

Table 1 PG_USER_MAPPING columns

Column

Type

Reference

Description

OID

OID

-

Row identifier (hidden attribute; must be explicitly selected)

umuser

OID

PG_AUTHID.oid

OID of the local role being mapped, 0 if the user mapping is public

umserver

OID

PG_FOREIGN_SERVER.oid

OID of the foreign server that contains this mapping

umoptions

Text[]

-

Option used for user mapping. It is a keyword=value string.