{"Entry":{"collection":"sql","key":"create-server","name":"CREATE SERVER","aliases":["createserver"],"metadata":{"aliases":["createserver"],"changed_in":["9.0","10"],"changes":[{"from":"8.3","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":[],"removed":[]},"status":"added","synopsis":null,"to":"8.4"},{"from":"8.4","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["parameters"],"removed":[]},"status":"changed","synopsis":{"added":["CREATE SERVER server_name [ TYPE 'server_type' ] [ VERSION 'server_version' ]","FOREIGN DATA WRAPPER fdw_name"],"removed":["CREATE SERVER servername [ TYPE 'servertype' ] [ VERSION 'serverversion' ]","FOREIGN DATA WRAPPER fdwname"]},"to":"9.0"},{"from":"9.0","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["notes"],"removed":[]},"status":"changed","synopsis":null,"to":"9.1"},{"from":"9.2","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["parameters","notes","examples","see_also"],"removed":[]},"status":"changed","synopsis":null,"to":"9.3"},{"from":"9.6","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["parameters"],"removed":[]},"status":"changed","synopsis":{"added":["CREATE SERVER [IF NOT EXISTS] server_name [ TYPE 'server_type' ] [ VERSION 'server_version' ]"],"removed":[]},"to":"10"},{"from":"10","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["notes"],"removed":[]},"status":"changed","synopsis":null,"to":"11"},{"from":"18","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description"],"removed":[]},"status":"changed","synopsis":null,"to":"19"}],"content_hash":"667b5ee598761e044f2e8e11a41123d0eb82e6c05a2c1be4e4b7fb1f203b12f1","derived_content_hash":"55ed0b4b67b1934a274c128c697ba6fc84f1d888f8ef773ef3672764ca458158","editorial":{},"first_version":"8.4","group":"foreign","imported_at":"2026-09-30T17:43:38.828174+08:00","last_version":"20","name":"CREATE SERVER","object":"SERVER","position":9007,"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"],"purpose":"define a new foreign server","purpose_zh":"","related":["alter-server","drop-server","create-foreign-data-wrapper","create-foreign-table","create-user-mapping"],"repair_provenance":{"original_source_revision":"wiki-repair-20261023:ae2f8c6bb254e1c29c74cb83e9ea26c1c07446160e8d587275166c7fe1022e48","receipt_sha256":"ab0c143f6010ce18f647dcbf00bd3821ceb7d71a2cd124064195d97b45e3625d","repair":"wiki-repair-20261023"},"slug":"create-server","source_rev":"wiki-repair-20261023:155b4ff5df97cfb9ce11a2a39ac6bd94309990bc662508c4c034ba873b67b6a6","synopsis":"CREATE SERVER [ IF NOT EXISTS ] server_name [ TYPE 'server_type' ] [ VERSION 'server_version' ]\nFOREIGN DATA WRAPPER fdw_name\n[ OPTIONS ( option 'value' [, ... ] ) ]","verb":"CREATE"}},"Definition":{"Collection":"sql","Key":"create-server","SourceDatabase":"center","Version":"18","SourceTable":"sqlcmd","SourceKey":"create-server","SourceRevision":"wiki-repair-20261023:155b4ff5df97cfb9ce11a2a39ac6bd94309990bc662508c4c034ba873b67b6a6","Facts":{"anchor":"SQL-CREATESERVER","description_zh":"定义一个新的外部服务器","description_zh_html":"\u003cpre\u003eCREATE SERVER [ IF NOT EXISTS ] server_name [ TYPE \u0026#x27;server_type\u0026#x27; ] [ VERSION \u0026#x27;server_version\u0026#x27; ]\nFOREIGN DATA WRAPPER fdw_name\n[ OPTIONS ( option \u0026#x27;value\u0026#x27; [, ... ] ) ]\u003c/pre\u003e\u003csection\u003e\u003ch2\u003e描述\u003c/h2\u003e\u003cp\u003e\n\u003ccode class=\"command\"\u003eCREATE SERVER\u003c/code\u003e 定义一个新的外部服务器。定义该服务器的用户将成为其拥有者。\n  \u003c/p\u003e\u003cp\u003e\n   外部服务器通常封装外部数据包装器用来访问外部数据资源的连接信息。还可以通过用户映射指定额外的、特定于用户的连接信息。\n  \u003c/p\u003e\u003cp\u003e\n   服务器名称在数据库内必须唯一。\n  \u003c/p\u003e\u003cp\u003e\n   要创建服务器，必须在所使用的外部数据包装器上具有 \u003ccode class=\"literal\"\u003eUSAGE\u003c/code\u003e 权限。\n  \u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e参数\u003c/h2\u003e\u003cdiv class=\"variablelist\"\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"ZH18-AUTO-CREATE_SERVER-VARLISTENTRY-1\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eIF NOT EXISTS\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n      如果同名服务器已存在，则不要抛出错误。在这种情况下会发出一个通知。请注意，不能保证现有服务器与原本将要创建的服务器有任何相似之处。\n     \u003c/p\u003e\u003c/dd\u003e\u003cdt id=\"ZH18-AUTO-CREATE_SERVER-VARLISTENTRY-2\"\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003eserver_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n      要创建的外部服务器的名称。\n     \u003c/p\u003e\u003c/dd\u003e\u003cdt id=\"ZH18-AUTO-CREATE_SERVER-VARLISTENTRY-3\"\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003eserver_type\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n      可选的服务器类型，可能对外部数据包装器有用。\n     \u003c/p\u003e\u003c/dd\u003e\u003cdt id=\"ZH18-AUTO-CREATE_SERVER-VARLISTENTRY-4\"\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003eserver_version\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n      可选的服务器版本，可能对外部数据包装器有用。\n     \u003c/p\u003e\u003c/dd\u003e\u003cdt id=\"ZH18-AUTO-CREATE_SERVER-VARLISTENTRY-5\"\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003efdw_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n      管理该服务器的外部数据包装器的名称。\n     \u003c/p\u003e\u003c/dd\u003e\u003cdt id=\"ZH18-AUTO-CREATE_SERVER-VARLISTENTRY-6\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eOPTIONS ( \u003cem class=\"replaceable\"\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e '\u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e' [, ... ] )\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n      这个子句指定服务器的选项。这些选项通常定义该服务器的连接细节，但实际的名称和值取决于该服务器的外部数据包装器。\n     \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e注解\u003c/h2\u003e\u003cp\u003e\n   在使用 \u003ca class=\"xref\" href=\"/zh/docs/18/dblink.html\" title=\"F.11. dblink — 连接到其他 PostgreSQL 数据库\"\u003edblink\u003c/a\u003e 模块时，可以将外部服务器的名称用作 \u003ca class=\"xref\" href=\"/zh/docs/18/contrib-dblink-connect.html\" title=\"dblink_connect\"\u003e\u003cspan class=\"refentrytitle\"\u003edblink_connect\u003c/span\u003e\u003c/a\u003e 函数的一个参数，以指示连接参数。要以这种方式使用它，必须在该外部服务器上具有\n   \u003ccode class=\"literal\"\u003eUSAGE\u003c/code\u003e 权限。\n  \u003c/p\u003e\u003cp\u003e\n   如果外部服务器支持排序下推，那么它必须与本地服务器具有相同的排序顺序。\n  \u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e示例\u003c/h2\u003e\u003cp\u003e\n   创建一个使用外部数据包装器 \u003ccode class=\"literal\"\u003epostgres_fdw\u003c/code\u003e\n   的服务器 \u003ccode class=\"literal\"\u003emyserver\u003c/code\u003e：\n\u003c/p\u003e\u003cpre class=\"programlisting\"\u003e\nCREATE SERVER myserver FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'foo', dbname 'foodb', port '5432');\n\u003c/pre\u003e\u003cp\u003e\n   详见 \u003ca class=\"xref\" href=\"/zh/docs/18/postgres-fdw.html\" title=\"F.38. postgres_fdw — 访问存储在外部 PostgreSQL 服务器中的数据\"\u003epostgres_fdw\u003c/a\u003e。\n  \u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e兼容性\u003c/h2\u003e\u003cp\u003e\n\u003ccode class=\"command\"\u003eCREATE SERVER\u003c/code\u003e 符合 ISO/IEC 9075-9 (SQL/MED)。\n  \u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e另见\u003c/h2\u003e\u003cspan class=\"simplelist\"\u003e\u003ca class=\"xref\" href=\"/zh/docs/18/sql-alterserver.html\" title=\"ALTER SERVER\"\u003e\u003cspan class=\"refentrytitle\"\u003eALTER SERVER\u003c/span\u003e\u003c/a\u003e, \u003ca class=\"xref\" href=\"/zh/docs/18/sql-dropserver.html\" title=\"DROP SERVER\"\u003e\u003cspan class=\"refentrytitle\"\u003eDROP SERVER\u003c/span\u003e\u003c/a\u003e, \u003ca class=\"xref\" href=\"/zh/docs/18/sql-createforeigndatawrapper.html\" title=\"CREATE FOREIGN DATA WRAPPER\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE FOREIGN DATA WRAPPER\u003c/span\u003e\u003c/a\u003e, \u003ca class=\"xref\" href=\"/zh/docs/18/sql-createforeigntable.html\" title=\"CREATE FOREIGN TABLE\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE FOREIGN TABLE\u003c/span\u003e\u003c/a\u003e, \u003ca class=\"xref\" href=\"/zh/docs/18/sql-createusermapping.html\" title=\"CREATE USER MAPPING\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE USER MAPPING\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e\u003c/section\u003e","file":"sql-createserver.html","lang":"en","name":"CREATE SERVER","purpose":"define a new foreign server","purpose_zh":"定义一个新的外部服务器","related":["alter-server","drop-server","create-foreign-data-wrapper","create-foreign-table","create-user-mapping"],"sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eCREATE SERVER\u003c/code\u003e defines a new foreign server. The user who defines the server becomes its owner.\u003c/p\u003e\u003cp\u003eA foreign server typically encapsulates connection information that a foreign-data wrapper uses to access an external data resource. Additional user-specific connection information may be specified by means of user mappings.\u003c/p\u003e\u003cp\u003eThe server name must be unique within the database.\u003c/p\u003e\u003cp\u003eCreating a server requires \u003ccode class=\"literal\"\u003eUSAGE\u003c/code\u003e privilege on the foreign-data wrapper being used.\u003c/p\u003e","key":"description","title":"Description"},{"html":"\u003cdiv class=\"variablelist\"\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eIF NOT EXISTS\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eDo not throw an error if a server with the same name already exists. A notice is issued in this case. Note that there is no guarantee that the existing server is anything like the one that would have been created.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003eserver_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name of the foreign server to be created.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003eserver_type\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eOptional server type, potentially useful to foreign-data wrappers.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003eserver_version\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eOptional server version, potentially useful to foreign-data wrappers.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003efdw_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name of the foreign-data wrapper that manages the server.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eOPTIONS ( \u003cem class=\"replaceable\"\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e '\u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e' [, ... ] )\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThis clause specifies the options for the server. The options typically define the connection details of the server, but the actual names and values are dependent on the server's foreign-data wrapper.\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"Parameters"},{"html":"\u003cp\u003eWhen using the \u003ca href=\"/docs/18/dblink.html\" title=\"F.11. dblink — connect to other PostgreSQL databases\"\u003edblink\u003c/a\u003e module, a foreign server's name can be used as an argument of the \u003ca href=\"/docs/18/contrib-dblink-connect.html\" title=\"dblink_connect\"\u003e\u003cspan class=\"refentrytitle\"\u003edblink_connect\u003c/span\u003e\u003c/a\u003e function to indicate the connection parameters. It is necessary to have the \u003ccode class=\"literal\"\u003eUSAGE\u003c/code\u003e privilege on the foreign server to be able to use it in this way.\u003c/p\u003e\u003cp\u003eIf the foreign server supports sort pushdown, it is necessary for it to have the same sort ordering as the local server.\u003c/p\u003e","key":"notes","title":"Notes"},{"html":"\u003cp\u003eCreate a server \u003ccode class=\"literal\"\u003emyserver\u003c/code\u003e that uses the foreign-data wrapper \u003ccode class=\"literal\"\u003epostgres_fdw\u003c/code\u003e:\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eCREATE SERVER myserver FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'foo', dbname 'foodb', port '5432');\n\u003c/pre\u003e\u003cp\u003eSee \u003ca href=\"/docs/18/postgres-fdw.html\" title=\"F.38. postgres_fdw — access data stored in external PostgreSQL servers\"\u003epostgres_fdw\u003c/a\u003e for more details.\u003c/p\u003e","key":"examples","title":"Examples"},{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eCREATE SERVER\u003c/code\u003e conforms to ISO/IEC 9075-9 (SQL/MED).\u003c/p\u003e","key":"compatibility","title":"Compatibility"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/alter-server/?v=18\" title=\"ALTER SERVER\"\u003e\u003cspan class=\"refentrytitle\"\u003eALTER SERVER\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/drop-server/?v=18\" title=\"DROP SERVER\"\u003e\u003cspan class=\"refentrytitle\"\u003eDROP SERVER\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/create-foreign-data-wrapper/?v=18\" title=\"CREATE FOREIGN DATA WRAPPER\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE FOREIGN DATA WRAPPER\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/create-foreign-table/?v=18\" title=\"CREATE FOREIGN TABLE\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE FOREIGN TABLE\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/create-user-mapping/?v=18\" title=\"CREATE USER MAPPING\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE USER MAPPING\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e","key":"see_also","title":"See Also"}],"sections_same_as":"","slug":"18","synopsis_html":"CREATE SERVER [ IF NOT EXISTS ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003eserver_name\u003c/code\u003e\u003c/em\u003e [ TYPE '\u003cem class=\"replaceable\"\u003e\u003ccode\u003eserver_type\u003c/code\u003e\u003c/em\u003e' ] [ VERSION '\u003cem class=\"replaceable\"\u003e\u003ccode\u003eserver_version\u003c/code\u003e\u003c/em\u003e' ]\n    FOREIGN DATA WRAPPER \u003cem class=\"replaceable\"\u003e\u003ccode\u003efdw_name\u003c/code\u003e\u003c/em\u003e\n    [ OPTIONS ( \u003cem class=\"replaceable\"\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e '\u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e' [, ... ] ) ]","synopsis_text":"CREATE SERVER [ IF NOT EXISTS ] server_name [ TYPE 'server_type' ] [ VERSION 'server_version' ]\nFOREIGN DATA WRAPPER fdw_name\n[ OPTIONS ( option 'value' [, ... ] ) ]","translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/sql-createserver.html","sha256":"c083178b796728c1c52eb31ceeefa208f386b2d2647e914f14eb018037d231ee"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-pgdoc"},"ManualEvidence":{},"MeasuredEvidence":{}},"Text":{"Collection":"sql","Key":"create-server","SourceDatabase":"center","Version":"18","Locale":"en","Title":"CREATE SERVER","Summary":"define a new foreign server","BodyHTML":"\u003cpre\u003eCREATE SERVER [ IF NOT EXISTS ] server_name [ TYPE \u0026#39;server_type\u0026#39; ] [ VERSION \u0026#39;server_version\u0026#39; ]\nFOREIGN DATA WRAPPER fdw_name\n[ OPTIONS ( option \u0026#39;value\u0026#39; [, ... ] ) ]\u003c/pre\u003e\u003csection\u003e\u003ch2\u003eDescription\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eCREATE SERVER\u003c/code\u003e defines a new foreign server. The user who defines the server becomes its owner.\u003c/p\u003e\u003cp\u003eA foreign server typically encapsulates connection information that a foreign-data wrapper uses to access an external data resource. Additional user-specific connection information may be specified by means of user mappings.\u003c/p\u003e\u003cp\u003eThe server name must be unique within the database.\u003c/p\u003e\u003cp\u003eCreating a server requires \u003ccode\u003eUSAGE\u003c/code\u003e privilege on the foreign-data wrapper being used.\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003eParameters\u003c/h2\u003e\u003cdiv\u003e\u003cdl\u003e\u003cdt\u003e\u003cspan\u003e\u003ccode\u003eIF NOT EXISTS\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eDo not throw an error if a server with the same name already exists. A notice is issued in this case. Note that there is no guarantee that the existing server is anything like the one that would have been created.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003eserver_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name of the foreign server to be created.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003eserver_type\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eOptional server type, potentially useful to foreign-data wrappers.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003eserver_version\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eOptional server version, potentially useful to foreign-data wrappers.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003efdw_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name of the foreign-data wrapper that manages the server.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003ccode\u003eOPTIONS ( \u003cem\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e \u0026#39;\u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e\u0026#39; [, ... ] )\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThis clause specifies the options for the server. The options typically define the connection details of the server, but the actual names and values are dependent on the server\u0026#39;s foreign-data wrapper.\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003eNotes\u003c/h2\u003e\u003cp\u003eWhen using the \u003ca href=\"/docs/18/dblink.html\" rel=\"nofollow\"\u003edblink\u003c/a\u003e module, a foreign server\u0026#39;s name can be used as an argument of the \u003ca href=\"/docs/18/contrib-dblink-connect.html\" title=\"dblink_connect\" rel=\"nofollow\"\u003e\u003cspan\u003edblink_connect\u003c/span\u003e\u003c/a\u003e function to indicate the connection parameters. It is necessary to have the \u003ccode\u003eUSAGE\u003c/code\u003e privilege on the foreign server to be able to use it in this way.\u003c/p\u003e\u003cp\u003eIf the foreign server supports sort pushdown, it is necessary for it to have the same sort ordering as the local server.\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003eExamples\u003c/h2\u003e\u003cp\u003eCreate a server \u003ccode\u003emyserver\u003c/code\u003e that uses the foreign-data wrapper \u003ccode\u003epostgres_fdw\u003c/code\u003e:\u003c/p\u003e\u003cpre\u003eCREATE SERVER myserver FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host \u0026#39;foo\u0026#39;, dbname \u0026#39;foodb\u0026#39;, port \u0026#39;5432\u0026#39;);\n\u003c/pre\u003e\u003cp\u003eSee \u003ca href=\"/docs/18/postgres-fdw.html\" rel=\"nofollow\"\u003epostgres_fdw\u003c/a\u003e for more details.\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003eCompatibility\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eCREATE SERVER\u003c/code\u003e conforms to ISO/IEC 9075-9 (SQL/MED).\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003eSee Also\u003c/h2\u003e\u003cspan\u003e\u003ca href=\"/wiki/sql/alter-server/?v=18\" title=\"ALTER SERVER\" rel=\"nofollow\"\u003e\u003cspan\u003eALTER SERVER\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/drop-server/?v=18\" title=\"DROP SERVER\" rel=\"nofollow\"\u003e\u003cspan\u003eDROP SERVER\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/create-foreign-data-wrapper/?v=18\" title=\"CREATE FOREIGN DATA WRAPPER\" rel=\"nofollow\"\u003e\u003cspan\u003eCREATE FOREIGN DATA WRAPPER\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/create-foreign-table/?v=18\" title=\"CREATE FOREIGN TABLE\" rel=\"nofollow\"\u003e\u003cspan\u003eCREATE FOREIGN TABLE\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/create-user-mapping/?v=18\" title=\"CREATE USER MAPPING\" rel=\"nofollow\"\u003e\u003cspan\u003eCREATE USER MAPPING\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e\u003c/section\u003e","SourceRevision":"wiki-repair-20261023:155b4ff5df97cfb9ce11a2a39ac6bd94309990bc662508c4c034ba873b67b6a6","ContentHash":"17f61c174a4bcbeba1bffdab4f4c297d7110892733aec6032b4ddadf72cc68b3","Payload":{"related":["alter-server","drop-server","create-foreign-data-wrapper","create-foreign-table","create-user-mapping"],"sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eCREATE SERVER\u003c/code\u003e defines a new foreign server. The user who defines the server becomes its owner.\u003c/p\u003e\u003cp\u003eA foreign server typically encapsulates connection information that a foreign-data wrapper uses to access an external data resource. Additional user-specific connection information may be specified by means of user mappings.\u003c/p\u003e\u003cp\u003eThe server name must be unique within the database.\u003c/p\u003e\u003cp\u003eCreating a server requires \u003ccode class=\"literal\"\u003eUSAGE\u003c/code\u003e privilege on the foreign-data wrapper being used.\u003c/p\u003e","key":"description","title":"Description"},{"html":"\u003cdiv class=\"variablelist\"\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eIF NOT EXISTS\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eDo not throw an error if a server with the same name already exists. A notice is issued in this case. Note that there is no guarantee that the existing server is anything like the one that would have been created.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003eserver_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name of the foreign server to be created.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003eserver_type\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eOptional server type, potentially useful to foreign-data wrappers.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003eserver_version\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eOptional server version, potentially useful to foreign-data wrappers.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003efdw_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name of the foreign-data wrapper that manages the server.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eOPTIONS ( \u003cem class=\"replaceable\"\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e '\u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e' [, ... ] )\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThis clause specifies the options for the server. The options typically define the connection details of the server, but the actual names and values are dependent on the server's foreign-data wrapper.\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"Parameters"},{"html":"\u003cp\u003eWhen using the \u003ca href=\"/docs/18/dblink.html\" title=\"F.11. dblink — connect to other PostgreSQL databases\"\u003edblink\u003c/a\u003e module, a foreign server's name can be used as an argument of the \u003ca href=\"/docs/18/contrib-dblink-connect.html\" title=\"dblink_connect\"\u003e\u003cspan class=\"refentrytitle\"\u003edblink_connect\u003c/span\u003e\u003c/a\u003e function to indicate the connection parameters. It is necessary to have the \u003ccode class=\"literal\"\u003eUSAGE\u003c/code\u003e privilege on the foreign server to be able to use it in this way.\u003c/p\u003e\u003cp\u003eIf the foreign server supports sort pushdown, it is necessary for it to have the same sort ordering as the local server.\u003c/p\u003e","key":"notes","title":"Notes"},{"html":"\u003cp\u003eCreate a server \u003ccode class=\"literal\"\u003emyserver\u003c/code\u003e that uses the foreign-data wrapper \u003ccode class=\"literal\"\u003epostgres_fdw\u003c/code\u003e:\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eCREATE SERVER myserver FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'foo', dbname 'foodb', port '5432');\n\u003c/pre\u003e\u003cp\u003eSee \u003ca href=\"/docs/18/postgres-fdw.html\" title=\"F.38. postgres_fdw — access data stored in external PostgreSQL servers\"\u003epostgres_fdw\u003c/a\u003e for more details.\u003c/p\u003e","key":"examples","title":"Examples"},{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eCREATE SERVER\u003c/code\u003e conforms to ISO/IEC 9075-9 (SQL/MED).\u003c/p\u003e","key":"compatibility","title":"Compatibility"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/alter-server/?v=18\" title=\"ALTER SERVER\"\u003e\u003cspan class=\"refentrytitle\"\u003eALTER SERVER\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/drop-server/?v=18\" title=\"DROP SERVER\"\u003e\u003cspan class=\"refentrytitle\"\u003eDROP SERVER\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/create-foreign-data-wrapper/?v=18\" title=\"CREATE FOREIGN DATA WRAPPER\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE FOREIGN DATA WRAPPER\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/create-foreign-table/?v=18\" title=\"CREATE FOREIGN TABLE\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE FOREIGN TABLE\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/create-user-mapping/?v=18\" title=\"CREATE USER MAPPING\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE USER MAPPING\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e","key":"see_also","title":"See Also"}],"sections_same_as":"","synopsis_html":"CREATE SERVER [ IF NOT EXISTS ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003eserver_name\u003c/code\u003e\u003c/em\u003e [ TYPE '\u003cem class=\"replaceable\"\u003e\u003ccode\u003eserver_type\u003c/code\u003e\u003c/em\u003e' ] [ VERSION '\u003cem class=\"replaceable\"\u003e\u003ccode\u003eserver_version\u003c/code\u003e\u003c/em\u003e' ]\n    FOREIGN DATA WRAPPER \u003cem class=\"replaceable\"\u003e\u003ccode\u003efdw_name\u003c/code\u003e\u003c/em\u003e\n    [ OPTIONS ( \u003cem class=\"replaceable\"\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e '\u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e' [, ... ] ) ]","synopsis_text":"CREATE SERVER [ IF NOT EXISTS ] server_name [ TYPE 'server_type' ] [ VERSION 'server_version' ]\nFOREIGN DATA WRAPPER fdw_name\n[ OPTIONS ( option 'value' [, ... ] ) ]"}},"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}