{"Entry":{"collection":"catalog","key":"pg_user_mapping","name":"pg_user_mapping","aliases":[],"metadata":{"changed_in":["12"],"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.","name":"umoptions","to":"User mapping specific options, as \"keyword=value\" strings"}],"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","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":[{"attribute":"hidden","from":true,"name":"oid","to":false}],"description_changed":false,"descriptions":[],"from":"11","listing":[],"order":false,"removed":[],"status":"changed","to":"12","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":4,"content_hash":"b9846dc94aec2ceddf49d1032a4bee7419daea9e5875f17da0ea3a26031aec1a","derived_content_hash":"e6bc4ff86a0cf3879d98ea525f8392545bde5eb9012ab7c955e7328f45ed3e62","first_version":"8.4","imported_at":"2026-09-30T00:40:56.42419+08:00","kind":"catalog","last_version":"20","name":"pg_user_mapping","position":151,"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":"r","shared":false,"source_rev":"catalog-bilingual-repair:30266054030f0b15264cd2635cf5d4e19ccc5b7cdfa6c551415c3b0cb7cce00e","summary":"The catalog pg_user_mapping stores the mappings from local user to remote.","summary_zh":"目录 pg_user_mapping 存储从本地用户到远程用户的映射。对这个目录的访问对普通用户有限制，可使用视图 pg_user_mappings 替代。"}},"Definition":{"Collection":"catalog","Key":"pg_user_mapping","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_user_mapping","SourceRevision":"catalog-bilingual-repair:30266054030f0b15264cd2635cf5d4e19ccc5b7cdfa6c551415c3b0cb7cce00e","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"行标识符","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"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":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"The OID of the foreign server that contains this mapping","description_zh":"包含此映射的外部服务器的 OID","documented":true,"documented_name":"umserver","hidden":false,"name":"umserver","not_null":true,"references":"pg_foreign_server.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":4,"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 catalog pg_user_mapping stores the mappings from local user to remote. Access to this catalog is restricted from normal users, use the view pg_user_mappings instead.","description_zh":"目录 pg_user_mapping 存储从本地用户到远程用户的映射。对这个目录的访问对普通用户有限制，可使用视图 pg_user_mappings 替代。","description_zh_html":"\u003cp\u003e目录 pg_user_mapping 存储从本地用户到远程用户的映射。对这个目录的访问对普通用户有限制，可使用视图 pg_user_mappings 替代。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.67.4","file":"catalog-pg-user-mapping.html","lang":"en","sha256":"b7e957b8793e364063d86bd456685d0f0308302a2d134cd2a4106ae790b68fcf","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","umuser","umserver","umoptions"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-user-mapping.html","sha256":"7b9a81698beac43bfc37e9bfab0bacd602cef2f5d0a5a6213e15a977f4d3ff0b","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:9aa94a2e66be6f473035051fc848772bd6693ccf5d9bcf2f99119121f7a36a75","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.67.4","file":"catalog-pg-user-mapping.html","lang":"en","sha256":"b7e957b8793e364063d86bd456685d0f0308302a2d134cd2a4106ae790b68fcf","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-user-mapping.html","sha256":"7b9a81698beac43bfc37e9bfab0bacd602cef2f5d0a5a6213e15a977f4d3ff0b","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:9aa94a2e66be6f473035051fc848772bd6693ccf5d9bcf2f99119121f7a36a75","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","umuser","umserver","umoptions"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_user_mapping","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_user_mapping","Summary":"The catalog pg_user_mapping stores the mappings from local user to remote. Access to this catalog is restricted from normal users, use the view pg_user_mappings instead.","BodyHTML":"\u003cp\u003eThe catalog pg_user_mapping stores the mappings from local user to remote. Access to this catalog is restricted from normal users, use the view pg_user_mappings instead.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:30266054030f0b15264cd2635cf5d4e19ccc5b7cdfa6c551415c3b0cb7cce00e","ContentHash":"f8e8ec76586b6663f4f1fc8708f39e43319f84cc657dd747a85122bcb341b239","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"行标识符","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"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":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"The OID of the foreign server that contains this mapping","description_zh":"包含此映射的外部服务器的 OID","documented":true,"documented_name":"umserver","hidden":false,"name":"umserver","not_null":true,"references":"pg_foreign_server.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":4,"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 catalog pg_user_mapping stores the mappings from local user to remote. Access to this catalog is restricted from normal users, use the view pg_user_mappings instead."}},"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}