Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-3.x)/ System Catalogs and System Views/ System Views/ PG_USER_MAPPINGS
Updated on 2025-08-19 GMT+08:00
View PDF

PG_USER_MAPPINGS

PG_USER_MAPPINGS displays user mapping information. All users can view the report.

Table 1 PG_USER_MAPPINGS columns

Name

Type

Reference

Description

umid

oid

PG_USER_MAPPING.oid

OID of the user mapping.

srvid

oid

PG_FOREIGN_SERVER.oid

OID of the foreign server that contains the 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. If the current user is the owner of the foreign server, it is a string in the format of "keyword=value". Otherwise, it is null.
Parent topic: System Views