PG_USER_MAPPINGS¶
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.
Column | Type | Reference | Description |
|---|---|---|---|
umid | OID | PG_USER_MAPPING.oid | OID of the user mapping |
srvid | 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. |