PostgreSQL

PostgreSQL Elephant Logo

51.64. pg_user_mapping

The catalog pg_user_mapping stores the mappings from local user to remote. Access to this catalog is restricted from normal users, use the view pg_user_mappings instead.

Table 51.65. pg_user_mapping Columns

Name Type References Description

oid

oid

Row identifier

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

The OID of the foreign server that contains this mapping

umoptions

text[]

User mapping specific options, as “[.quote]#keyword=value”# strings

+

Prev Up Next

51.63. pg_type

Home

51.65. System Views

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Copyright © 1996-2023 The PostgreSQL Global Development Group