The view pg_user_mappings provides access to information about user mappings. This is essentially a publicly readable view of pg_user_mapping that leaves out the options field if the user has no rights to use it.
Table 45-72. pg_user_mappings Columns
|umid||oid||pg_user_mapping.oid||OID of the user mapping|
|srvid||oid||pg_foreign_server.oid||The 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, as "keyword=value" strings, if the current user is the owner of the foreign server, else null|
Please use this form to add your own comments regarding your experience with particular features of PostgreSQL, clarifications of the documentation, or hints for other users. Please note, this is not a support forum, and your IP address will be logged. If you have a question or need help, please see the faq, try a mailing list, or join us on IRC. Note that submissions containing URLs or other keywords commonly found in 'spam' comments may be silently discarded. Please contact the webmaster if you think this is happening to you in error.
Proceed to the comment form.