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

PG_USER_MAPPINGS

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

PG_USER_MAPPINGS displays information about user mappings.

This is essentially a publicly readable view of PG_USER_MAPPING that leaves out the options column if the user has no rights to use it.

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 this 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, its value is keyword=value strings. Otherwise, its value is null.

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