forked from docs/doc-exports
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com> Co-authored-by: Lu, Huayi <luhuayi@huawei.com> Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
6.8 KiB
6.8 KiB
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.
Name |
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. |
Parent topic: System Views