{"Entry":{"collection":"catalog","key":"pg_foreign_data_wrapper","name":"pg_foreign_data_wrapper","aliases":[],"metadata":{"changed_in":["9.1","12","19"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.3","order":false,"removed":[],"status":"added","to":"8.4","types":[]},{"added":["fdwhandler"],"attributes":[],"description_changed":false,"descriptions":[{"from":"References a validator function that is responsible for checking the validity of the generic options given to the foreign-data wrapper, as well as to foreign servers and user mappings using the foreign-data wrapper. Zero if no validator is provided.","name":"fdwvalidator","to":"References a validator function that is responsible for checking the validity of the options given to the foreign-data wrapper, as well as options for foreign servers and user mappings using the foreign-data wrapper. Zero if no validator is provided"}],"from":"9.0","listing":[],"order":false,"removed":[],"status":"changed","to":"9.1","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Foreign-data wrapper specific options, as \"keyword=value\" strings","name":"fdwoptions","to":"Foreign-data wrapper 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":"Access privileges; see GRANT and REVOKE for details","name":"fdwacl","to":"Access privileges; see Section 5.7 for details"}],"from":"11","listing":[],"order":false,"removed":[],"status":"changed","to":"12","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Access privileges; see Section 5.7 for details","name":"fdwacl","to":"Access privileges; see Section 5.8 for details"}],"from":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]},{"added":["fdwconnection"],"attributes":[],"description_changed":false,"descriptions":[{"from":"Access privileges; see Section 5.8 for details","name":"fdwacl","to":"Access privileges; see Section 5.9 for details"}],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]}],"column_count":8,"content_hash":"42a528c24362d9eba382d30851300d2ac89b9458653ce4f3f075b624dc7a6d04","derived_content_hash":"35a38dff58b13dd40a4b286aacda86318eaa261fa91656f4e3392c8a6240c9da","first_version":"8.4","imported_at":"2026-09-30T00:40:55.537399+08:00","kind":"catalog","last_version":"20","name":"pg_foreign_data_wrapper","position":30,"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:18eba27f746e62d296d8276196883ac74d3837473ed94b0d926d51fcdcbeb8cb","summary":"The catalog pg_foreign_data_wrapper stores foreign-data wrapper definitions.","summary_zh":"目录 pg_foreign_data_wrapper 存储外部数据包装器定义。外部数据包装器是一种访问位于外部服务器上数据的机制。"}},"Definition":{"Collection":"catalog","Key":"pg_foreign_data_wrapper","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_foreign_data_wrapper","SourceRevision":"catalog-bilingual-repair:18eba27f746e62d296d8276196883ac74d3837473ed94b0d926d51fcdcbeb8cb","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":"Name of the foreign-data wrapper","description_zh":"外部数据包装器的名字","documented":true,"documented_name":"fdwname","hidden":false,"name":"fdwname","not_null":true,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Owner of the foreign-data wrapper","description_zh":"外部数据包装器的拥有者","documented":true,"documented_name":"fdwowner","hidden":false,"name":"fdwowner","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"References a handler function that is responsible for supplying execution routines for the foreign-data wrapper. Zero if no handler is provided","description_zh":"指向一个负责为外部数据包装器提供执行例程的处理函数；如果没有提供处理函数则为零","documented":true,"documented_name":"fdwhandler","hidden":false,"name":"fdwhandler","not_null":true,"references":"pg_proc.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"References a validator function that is responsible for checking the validity of the options given to the foreign-data wrapper, as well as options for foreign servers and user mappings using the foreign-data wrapper. Zero if no validator is provided","description_zh":"引用一个验证函数，负责检查传给此外部数据包装器的选项，以及使用该包装器的外部服务器和用户映射的选项是否有效。如果未提供验证函数，则为零","documented":true,"documented_name":"fdwvalidator","hidden":false,"name":"fdwvalidator","not_null":true,"references":"pg_proc.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":6,"description":"Access privileges; see Section 5.8 for details","description_zh":"访问权限，详见第 5.8 节","documented":true,"documented_name":"fdwacl","hidden":false,"name":"fdwacl","not_null":false,"references":"","type":"aclitem[]","type_modifier":-1,"type_oid":1034,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":7,"description":"Foreign-data wrapper specific options, as “keyword=value” strings","description_zh":"外部数据包装器特定选项，以“keyword=value”字符串形式","documented":true,"documented_name":"fdwoptions","hidden":false,"name":"fdwoptions","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009,"zh_from":"same-version-manual"}],"description":"The catalog pg_foreign_data_wrapper stores foreign-data wrapper definitions. A foreign-data wrapper is the mechanism by which external data, residing on foreign servers, is accessed.","description_zh":"目录 pg_foreign_data_wrapper 存储外部数据包装器定义。外部数据包装器是一种访问位于外部服务器上数据的机制。","description_zh_html":"\u003cp\u003e目录 pg_foreign_data_wrapper 存储外部数据包装器定义。外部数据包装器是一种访问位于外部服务器上数据的机制。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.25.4","file":"catalog-pg-foreign-data-wrapper.html","lang":"en","sha256":"041949873960933db1292a840b2348ff8d64af37af09ceb1db72e368f0d8a531","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","fdwname","fdwowner","fdwhandler","fdwvalidator","fdwacl","fdwoptions"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-foreign-data-wrapper.html","sha256":"3327c70926be590c87c4ade39f04bf9e303a2e8437d322c4e22cf9392cbec4f1","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:27f13e4e822c32216454f0f623a2604645aee17d095d625bfaa6b804e112ca0a","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.25.4","file":"catalog-pg-foreign-data-wrapper.html","lang":"en","sha256":"041949873960933db1292a840b2348ff8d64af37af09ceb1db72e368f0d8a531","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-foreign-data-wrapper.html","sha256":"3327c70926be590c87c4ade39f04bf9e303a2e8437d322c4e22cf9392cbec4f1","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:27f13e4e822c32216454f0f623a2604645aee17d095d625bfaa6b804e112ca0a","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","fdwname","fdwowner","fdwhandler","fdwvalidator","fdwacl","fdwoptions"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_foreign_data_wrapper","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_foreign_data_wrapper","Summary":"The catalog pg_foreign_data_wrapper stores foreign-data wrapper definitions. A foreign-data wrapper is the mechanism by which external data, residing on foreign servers, is accessed.","BodyHTML":"\u003cp\u003eThe catalog pg_foreign_data_wrapper stores foreign-data wrapper definitions. A foreign-data wrapper is the mechanism by which external data, residing on foreign servers, is accessed.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:18eba27f746e62d296d8276196883ac74d3837473ed94b0d926d51fcdcbeb8cb","ContentHash":"899973e4293cdc2b8d6e2807975f80c41a9e8e5fdb928c1b4188f0b639db0a57","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":"Name of the foreign-data wrapper","description_zh":"外部数据包装器的名字","documented":true,"documented_name":"fdwname","hidden":false,"name":"fdwname","not_null":true,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Owner of the foreign-data wrapper","description_zh":"外部数据包装器的拥有者","documented":true,"documented_name":"fdwowner","hidden":false,"name":"fdwowner","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"References a handler function that is responsible for supplying execution routines for the foreign-data wrapper. Zero if no handler is provided","description_zh":"指向一个负责为外部数据包装器提供执行例程的处理函数；如果没有提供处理函数则为零","documented":true,"documented_name":"fdwhandler","hidden":false,"name":"fdwhandler","not_null":true,"references":"pg_proc.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"References a validator function that is responsible for checking the validity of the options given to the foreign-data wrapper, as well as options for foreign servers and user mappings using the foreign-data wrapper. Zero if no validator is provided","description_zh":"引用一个验证函数，负责检查传给此外部数据包装器的选项，以及使用该包装器的外部服务器和用户映射的选项是否有效。如果未提供验证函数，则为零","documented":true,"documented_name":"fdwvalidator","hidden":false,"name":"fdwvalidator","not_null":true,"references":"pg_proc.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":6,"description":"Access privileges; see Section 5.8 for details","description_zh":"访问权限，详见第 5.8 节","documented":true,"documented_name":"fdwacl","hidden":false,"name":"fdwacl","not_null":false,"references":"","type":"aclitem[]","type_modifier":-1,"type_oid":1034,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":7,"description":"Foreign-data wrapper specific options, as “keyword=value” strings","description_zh":"外部数据包装器特定选项，以“keyword=value”字符串形式","documented":true,"documented_name":"fdwoptions","hidden":false,"name":"fdwoptions","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009,"zh_from":"same-version-manual"}],"description":"The catalog pg_foreign_data_wrapper stores foreign-data wrapper definitions. A foreign-data wrapper is the mechanism by which external data, residing on foreign servers, is accessed."}},"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}