Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> PG_USER_MAPPING

PG_USER_MAPPING

Updated at: Jul 15, 2020 GMT+08:00

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

Name

Type

Reference

Description

oid

oid

-

Column 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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel