{"Entry":{"collection":"catalog","key":"pg_foreign_server","name":"pg_foreign_server","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":"Foreign server specific options, as \"keyword=value\" strings.","name":"srvoptions","to":"Foreign server specific options, as \"keyword=value\" strings"}],"from":"8.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.0","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[{"from":"The OID of the foreign-data wrapper of this foreign server","name":"srvfdw","to":"OID of the foreign-data wrapper of this foreign server"}],"from":"9.0","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.1","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Foreign server specific options, as \"keyword=value\" strings","name":"srvoptions","to":"Foreign server 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":"srvacl","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":"srvacl","to":"Access privileges; see Section 5.8 for details"}],"from":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Access privileges; see Section 5.8 for details","name":"srvacl","to":"Access privileges; see Section 5.9 for details"}],"from":"18","listing":[],"order":false,"removed":[],"status":"reworded","to":"19","types":[],"unlisted":[]}],"column_count":8,"content_hash":"aa73b42a286a556fa5a46bc3a9f424a82b7d42ad25f14fa4193224d5c457119c","first_version":"8.4","imported_at":"2026-09-30T00:40:55.543865+08:00","kind":"catalog","last_version":"20","name":"pg_foreign_server","position":31,"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:878739dd5489dec1ec19de79d57c15342b15bba36bf018da21b0ca01b254245d","summary":"The catalog pg_foreign_server stores foreign server definitions.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_foreign_server","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_foreign_server","SourceRevision":"english-manuals:878739dd5489dec1ec19de79d57c15342b15bba36bf018da21b0ca01b254245d","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 server","description_zh":"","documented":true,"documented_name":"srvname","hidden":false,"name":"srvname","not_null":true,"references":"","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":3,"description":"Owner of the foreign server","description_zh":"","documented":true,"documented_name":"srvowner","hidden":false,"name":"srvowner","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":4,"description":"OID of the foreign-data wrapper of this foreign server","description_zh":"","documented":true,"documented_name":"srvfdw","hidden":false,"name":"srvfdw","not_null":true,"references":"pg_foreign_data_wrapper.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":5,"description":"Type of the server (optional)","description_zh":"","documented":true,"documented_name":"srvtype","hidden":false,"name":"srvtype","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":6,"description":"Version of the server (optional)","description_zh":"","documented":true,"documented_name":"srvversion","hidden":false,"name":"srvversion","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":1,"attnum":7,"description":"Access privileges; see Section 5.8 for details","description_zh":"","documented":true,"documented_name":"srvacl","hidden":false,"name":"srvacl","not_null":false,"references":"","type":"aclitem[]","type_modifier":-1,"type_oid":1034},{"array_dimensions":1,"attnum":8,"description":"Foreign server specific options, as “keyword=value” strings","description_zh":"","documented":true,"documented_name":"srvoptions","hidden":false,"name":"srvoptions","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009}],"description":"The catalog pg_foreign_server stores foreign server definitions. A foreign server describes a source of external data, such as a remote server. Foreign servers are accessed via foreign-data wrappers.","description_zh":"","doc":{"anchor":"id-1.10.4.26.4","file":"catalog-pg-foreign-server.html","lang":"en","sha256":"fabc2a59cb34c0b7dd7863836eed9e1f8d48e66018c82ccdbbb6eab3df0404a8","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","srvname","srvowner","srvfdw","srvtype","srvversion","srvacl","srvoptions"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.26.4","file":"catalog-pg-foreign-server.html","lang":"en","sha256":"fabc2a59cb34c0b7dd7863836eed9e1f8d48e66018c82ccdbbb6eab3df0404a8","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","srvname","srvowner","srvfdw","srvtype","srvversion","srvacl","srvoptions"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_foreign_server","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_foreign_server","Summary":"目录pg_foreign_server存储外部服务器定义。外部服务器定义了外部数据的来源，例如一个远程服务器。外部服务器通过外部数据包装器来访问。","BodyHTML":"\u003cp\u003e目录pg_foreign_server存储外部服务器定义。外部服务器定义了外部数据的来源，例如一个远程服务器。外部服务器通过外部数据包装器来访问。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"3a368c95211462718bde8db3d8052850fd7af5bbc4318a3c1fdae47cef7a6b0b","Payload":{"columns":[{"description_zh":"行标识符","name":"oid","type":"oid","zh_from":"doc"},{"description_zh":"外部服务器的名字","name":"srvname","type":"name","zh_from":"doc"},{"description_zh":"外部服务器的拥有者","name":"srvowner","type":"oid","zh_from":"doc"},{"description_zh":"此外部服务器的外部数据包装器的OID","name":"srvfdw","type":"oid","zh_from":"doc"},{"description_zh":"服务器的类型（可选）","name":"srvtype","type":"text","zh_from":"doc"},{"description_zh":"服务器的版本（可选）","name":"srvversion","type":"text","zh_from":"doc"},{"description_zh":"访问权限，详见第 5.8 节","name":"srvacl","type":"aclitem[]","zh_from":"doc"},{"description_zh":"外部服务器特定选项，以“keyword=value”字符串形式","name":"srvoptions","type":"text[]","zh_from":"doc"}],"description_zh":"目录pg_foreign_server存储外部服务器定义。外部服务器定义了外部数据的来源，例如一个远程服务器。外部服务器通过外部数据包装器来访问。","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}