历史版本。 PostgreSQL 9.1 已结束支持。 2016-10-27. 请参阅 当前版本手册.
45.69. pg_user_mappings #
视图pg_user_mappings提供用户映射的信息。它本质上是
pg_user_mapping 的公开可读视图，但如果用户没有使用相应选项的权限，则会省略选项字段。
表 45.70. pg_user_mappings 列
| Name | Type | References | Description |
|---|---|---|---|
umid | oid | | OID of the user mapping |
srvid | oid | | The OID of the foreign server that contains this mapping |
srvname | text | Name of the foreign server | |
umuser | 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 |