_PG_USER_MAPPINGS
Stores mappings from local users to remote users, as described in Table 1. Only the sysadmin user has the permission to view this view.
Name |
Type |
Description |
---|---|---|
oid |
oid |
OID of the mapping from the local user to a remote user. |
umoptions |
text[] |
User mapping specific options, expressed in a string in the format of keyword=value. |
umuser |
oid |
OID of the local user being mapped (0 if the user mapping is public). |
authorization_identifier |
information_schema.sql_identifier |
Role of the local user. |
foreign_server_catalog |
information_schema.sql_identifier |
Name of the database where the foreign server is located (always the current database). |
foreign_server_name |
information_schema.sql_identifier |
Name of the foreign server. |
srvowner |
information_schema.sql_identifier |
Owner of the foreign server. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.