This page in other versions: 9.2 / 9.3 / 9.4 / 9.5 / current (9.6)  |  Development versions: devel  |  Unsupported versions: 8.4 / 9.0 / 9.1

48.53. 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 48-54. pg_user_mapping Columns

Name Type References 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 The OID of the foreign server that contains this mapping
umoptions text[]   User mapping specific options, as "keyword=value" strings

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.

Privacy Policy | About PostgreSQL
Copyright © 1996-2016 The PostgreSQL Global Development Group