{"Entry":{"collection":"catalog","key":"pg_user_mappings","name":"pg_user_mappings","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.3","order":false,"removed":[],"status":"added","to":"8.4","types":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"User mapping specific options, as \"keyword=value\" strings, if the current user is the owner of the foreign server, else null.","name":"umoptions","to":"User mapping specific options, as \"keyword=value\" strings, if the current user is the owner of the foreign server, else null"}],"from":"8.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.0","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"User mapping specific options, as \"keyword=value\" strings, if the current user is the owner of the foreign server, else null","name":"umoptions","to":"User mapping specific options, as \"keyword=value\" strings"}],"from":"9.1","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.2","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"User mapping specific options, as \"keyword=value\" strings","name":"umoptions","to":"User mapping specific options, as “keyword=value” strings"}],"from":"9.6","listing":[],"order":false,"removed":[],"status":"reworded","to":"10","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"OID of the local role being mapped, 0 if the user mapping is public","name":"umuser","to":"OID of the local role being mapped, or zero if the user mapping is public"}],"from":"13","listing":[],"order":false,"removed":[],"status":"reworded","to":"14","types":[],"unlisted":[]}],"column_count":6,"content_hash":"97b4c47029996c2184e9d23344af8ff8449ec2f21c5d7c594f12bf0489c5fa23","derived_content_hash":"93b2269b5ab02798e8b88b9eb31d4d742c9c43ac9e6b4a74bce80e6d07f23725","first_version":"8.4","imported_at":"2026-09-30T00:40:56.430153+08:00","kind":"view","last_version":"20","name":"pg_user_mappings","position":152,"present_in":["8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"catalog-bilingual-repair:823b037b1da7a91b1bb8d9d2f4af204f9e7d337278ee7a0abd31d36d53214bb0","summary":"The view pg_user_mappings provides access to information about user mappings.","summary_zh":"视图 pg_user_mappings 提供用户映射的信息。它本质上是 pg_user_mapping 的公开可读视图，但如果用户没有使用该用户映射的权限，则会省略选项字段。"}},"Definition":{"Collection":"catalog","Key":"pg_user_mappings","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_user_mappings","SourceRevision":"catalog-bilingual-repair:823b037b1da7a91b1bb8d9d2f4af204f9e7d337278ee7a0abd31d36d53214bb0","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of the user mapping","description_zh":"用户映射的 OID","documented":true,"documented_name":"umid","hidden":false,"name":"umid","not_null":false,"references":"pg_user_mapping.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"The OID of the foreign server that contains this mapping","description_zh":"包含该映射的外部服务器的 OID","documented":true,"documented_name":"srvid","hidden":false,"name":"srvid","not_null":false,"references":"pg_foreign_server.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Name of the foreign server","description_zh":"外部服务器名","documented":true,"documented_name":"srvname","hidden":false,"name":"srvname","not_null":false,"references":"pg_foreign_server.srvname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"OID of the local role being mapped, or zero if the user mapping is public","description_zh":"将要被映射的本地角色的 OID，如果用户映射是公共的则为零","documented":true,"documented_name":"umuser","hidden":false,"name":"umuser","not_null":false,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Name of the local user to be mapped","description_zh":"将被映射的本地用户名","documented":true,"documented_name":"usename","hidden":false,"name":"usename","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"User mapping specific options, as “keyword=value” strings","description_zh":"用户映射特定的选项，以“keyword=value”字符串形式","documented":true,"documented_name":"umoptions","hidden":false,"name":"umoptions","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009,"zh_from":"same-version-manual"}],"description":"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.","description_zh":"视图 pg_user_mappings 提供用户映射的信息。它本质上是 pg_user_mapping 的公开可读视图，但如果用户没有使用该用户映射的权限，则会省略选项字段。","description_zh_html":"\u003cp\u003e视图 pg_user_mappings 提供用户映射的信息。它本质上是 pg_user_mapping 的公开可读视图，但如果用户没有使用该用户映射的权限，则会省略选项字段。\u003c/p\u003e","doc":{"anchor":"id-1.10.5.40.4","file":"view-pg-user-mappings.html","lang":"en","sha256":"7c8ff2e29f3e04f4593c701e2ea2af67b21fba148dcadb8f89180854b98e05ca","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["umid","srvid","srvname","umuser","usename","umoptions"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-user-mappings.html","sha256":"44d26df46ae1b25abee56eafd6545cea9760083bcb35328ebd9e15b45cb557ae","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:930730db370c8890c02b90b4e69aee32122e2667ce0d9548c3ec6934007a442a","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.40.4","file":"view-pg-user-mappings.html","lang":"en","sha256":"7c8ff2e29f3e04f4593c701e2ea2af67b21fba148dcadb8f89180854b98e05ca","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-user-mappings.html","sha256":"44d26df46ae1b25abee56eafd6545cea9760083bcb35328ebd9e15b45cb557ae","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:930730db370c8890c02b90b4e69aee32122e2667ce0d9548c3ec6934007a442a","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["umid","srvid","srvname","umuser","usename","umoptions"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_user_mappings","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_user_mappings","Summary":"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.","BodyHTML":"\u003cp\u003eThe 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.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:823b037b1da7a91b1bb8d9d2f4af204f9e7d337278ee7a0abd31d36d53214bb0","ContentHash":"86d54f6f17c7541d8ab6992b859c78a0025b8a378c4a6dbb02ed35a6f5170b6e","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of the user mapping","description_zh":"用户映射的 OID","documented":true,"documented_name":"umid","hidden":false,"name":"umid","not_null":false,"references":"pg_user_mapping.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"The OID of the foreign server that contains this mapping","description_zh":"包含该映射的外部服务器的 OID","documented":true,"documented_name":"srvid","hidden":false,"name":"srvid","not_null":false,"references":"pg_foreign_server.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Name of the foreign server","description_zh":"外部服务器名","documented":true,"documented_name":"srvname","hidden":false,"name":"srvname","not_null":false,"references":"pg_foreign_server.srvname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"OID of the local role being mapped, or zero if the user mapping is public","description_zh":"将要被映射的本地角色的 OID，如果用户映射是公共的则为零","documented":true,"documented_name":"umuser","hidden":false,"name":"umuser","not_null":false,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Name of the local user to be mapped","description_zh":"将被映射的本地用户名","documented":true,"documented_name":"usename","hidden":false,"name":"usename","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"User mapping specific options, as “keyword=value” strings","description_zh":"用户映射特定的选项，以“keyword=value”字符串形式","documented":true,"documented_name":"umoptions","hidden":false,"name":"umoptions","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009,"zh_from":"same-version-manual"}],"description":"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."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}