{"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":"5c943e83cb85c1333b4e50ac98173fafe29fd81e54d15b112f81ff29ccf43609","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":"english-manuals:27f13e4e822c32216454f0f623a2604645aee17d095d625bfaa6b804e112ca0a","summary":"The catalog pg_foreign_data_wrapper stores foreign-data wrapper definitions.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_foreign_data_wrapper","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_foreign_data_wrapper","SourceRevision":"english-manuals:27f13e4e822c32216454f0f623a2604645aee17d095d625bfaa6b804e112ca0a","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},{"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},{"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},{"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},{"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},{"array_dimensions":1,"attnum":6,"description":"Access privileges; see Section 5.8 for details","description_zh":"","documented":true,"documented_name":"fdwacl","hidden":false,"name":"fdwacl","not_null":false,"references":"","type":"aclitem[]","type_modifier":-1,"type_oid":1034},{"array_dimensions":1,"attnum":7,"description":"Foreign-data wrapper specific options, as “keyword=value” strings","description_zh":"","documented":true,"documented_name":"fdwoptions","hidden":false,"name":"fdwoptions","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009}],"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":"","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"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.25.4","file":"catalog-pg-foreign-data-wrapper.html","lang":"en","sha256":"041949873960933db1292a840b2348ff8d64af37af09ceb1db72e368f0d8a531","slug":"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":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_foreign_data_wrapper","Summary":"目录pg_foreign_data_wrapper存储外部数据包装器定义。外部数据包装器是一种访问位于外部服务器上数据的机制。","BodyHTML":"\u003cp\u003e目录pg_foreign_data_wrapper存储外部数据包装器定义。外部数据包装器是一种访问位于外部服务器上数据的机制。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"7d2fc7f85d563f1003baeafdbc602056b047e2fcb4d3458ca34e32203010b881","Payload":{"columns":[{"description_zh":"行标识符","name":"oid","type":"oid","zh_from":"doc"},{"description_zh":"外部数据包装器的名字","name":"fdwname","type":"name","zh_from":"doc"},{"description_zh":"外部数据包装器的拥有者","name":"fdwowner","type":"oid","zh_from":"doc"},{"description_zh":"指向一个负责为外部数据包装器提供执行例程的处理函数；如果没有提供处理函数则为零","name":"fdwhandler","type":"oid","zh_from":"doc"},{"description_zh":"引用一个验证函数，负责检查传给此外部数据包装器的选项，以及使用该包装器的外部服务器和用户映射的选项是否有效。如果未提供验证函数，则为零","name":"fdwvalidator","type":"oid","zh_from":"doc"},{"description_zh":"访问权限，详见第 5.8 节","name":"fdwacl","type":"aclitem[]","zh_from":"doc"},{"description_zh":"外部数据包装器特定选项，以“keyword=value”字符串形式","name":"fdwoptions","type":"text[]","zh_from":"doc"}],"description_zh":"目录pg_foreign_data_wrapper存储外部数据包装器定义。外部数据包装器是一种访问位于外部服务器上数据的机制。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","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}