{"Entry":{"collection":"sql","key":"alter-server","name":"ALTER SERVER","aliases":["alterserver"],"metadata":{"aliases":["alterserver"],"changed_in":["9.0","9.2","9.5","14"],"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":["ALTER SERVER server_name [ VERSION 'new_version' ]","ALTER SERVER server_name OWNER TO new_owner"],"removed":["ALTER SERVER servername [ VERSION 'newversion' ]","ALTER SERVER servername OWNER TO new_owner"]},"to":"9.0"},{"from":"9.1","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["parameters","compatibility"],"removed":[]},"status":"changed","synopsis":{"added":["ALTER SERVER name [ VERSION 'new_version' ]","ALTER SERVER name OWNER TO new_owner","ALTER SERVER name RENAME TO new_name"],"removed":["ALTER SERVER server_name [ VERSION 'new_version' ]","ALTER SERVER server_name OWNER TO new_owner"]},"to":"9.2"},{"from":"9.4","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":[],"removed":[]},"status":"changed","synopsis":{"added":["ALTER SERVER name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }"],"removed":[]},"to":"9.5"},{"from":"13","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":[],"removed":[]},"status":"changed","synopsis":{"added":["ALTER SERVER name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }"],"removed":[]},"to":"14"},{"from":"15","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description"],"removed":[]},"status":"changed","synopsis":null,"to":"16"}],"content_hash":"bb5279c8df1b8890039ea32f1af284b53dbb661d6b3dd8ab712e9527fae79298","editorial":{},"first_version":"8.4","group":"foreign","imported_at":"2026-09-30T17:43:38.839547+08:00","last_version":"20","name":"ALTER SERVER","object":"SERVER","position":9008,"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":"change the definition of a foreign server","purpose_zh":"","related":["create-server","drop-server"],"slug":"alter-server","source_rev":"a709ab85","synopsis":"ALTER SERVER name [ VERSION 'new_version' ]\n[ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ]\nALTER SERVER name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\nALTER SERVER name RENAME TO new_name","verb":"ALTER"}},"Definition":{"Collection":"sql","Key":"alter-server","SourceDatabase":"center","Version":"18","SourceTable":"sqlcmd","SourceKey":"alter-server","SourceRevision":"a709ab85","Facts":{"anchor":"SQL-ALTERSERVER","file":"sql-alterserver.html","lang":"en","name":"ALTER SERVER","purpose":"change the definition of a foreign server","purpose_zh":"","related":["create-server","drop-server"],"sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER SERVER\u003c/code\u003e changes the definition of a foreign server. The first form changes the server version string or the generic options of the server (at least one clause is required). The second form changes the owner of the server.\u003c/p\u003e\u003cp\u003eTo alter the server you must be the owner of the server. Additionally to alter the owner, you must be able to \u003ccode class=\"literal\"\u003eSET ROLE\u003c/code\u003e to the new owning role, and you must have \u003ccode class=\"literal\"\u003eUSAGE\u003c/code\u003e privilege on the server's foreign-data wrapper. (Note that superusers satisfy all these criteria automatically.)\u003c/p\u003e","key":"description","title":"Description"},{"html":"\u003cdiv class=\"variablelist\"\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name of an existing server.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_version\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eNew server version.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eOPTIONS ( [ ADD | SET | DROP ] \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\u003eChange options for the server. \u003ccode class=\"literal\"\u003eADD\u003c/code\u003e, \u003ccode class=\"literal\"\u003eSET\u003c/code\u003e, and \u003ccode class=\"literal\"\u003eDROP\u003c/code\u003e specify the action to be performed. \u003ccode class=\"literal\"\u003eADD\u003c/code\u003e is assumed if no operation is explicitly specified. Option names must be unique; names and values are also validated using the server's foreign-data wrapper library.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_owner\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe user name of the new owner of the foreign server.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe new name for the foreign server.\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"Parameters"},{"html":"\u003cp\u003eAlter server \u003ccode class=\"literal\"\u003efoo\u003c/code\u003e, add connection options:\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eALTER SERVER foo OPTIONS (host 'foo', dbname 'foodb');\n\u003c/pre\u003e\u003cp\u003eAlter server \u003ccode class=\"literal\"\u003efoo\u003c/code\u003e, change version, change \u003ccode class=\"literal\"\u003ehost\u003c/code\u003e option:\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eALTER SERVER foo VERSION '8.4' OPTIONS (SET host 'baz');\n\u003c/pre\u003e","key":"examples","title":"Examples"},{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER SERVER\u003c/code\u003e conforms to ISO/IEC 9075-9 (SQL/MED). The \u003ccode class=\"literal\"\u003eOWNER TO\u003c/code\u003e and \u003ccode class=\"literal\"\u003eRENAME\u003c/code\u003e forms are PostgreSQL extensions.\u003c/p\u003e","key":"compatibility","title":"Compatibility"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/create-server/?v=18\" title=\"CREATE SERVER\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE 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\u003c/span\u003e","key":"see_also","title":"See Also"}],"sections_same_as":"","slug":"18","synopsis_html":"ALTER SERVER \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e [ VERSION '\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_version\u003c/code\u003e\u003c/em\u003e' ]\n    [ OPTIONS ( [ ADD | SET | DROP ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e ['\u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e'] [, ... ] ) ]\nALTER SERVER \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e OWNER TO { \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_owner\u003c/code\u003e\u003c/em\u003e | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\nALTER SERVER \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e RENAME TO \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e","synopsis_text":"ALTER SERVER name [ VERSION 'new_version' ]\n[ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ]\nALTER SERVER name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\nALTER SERVER name RENAME TO new_name"},"ManualEvidence":{},"MeasuredEvidence":{}},"Text":{"Collection":"sql","Key":"alter-server","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"ALTER SERVER","Summary":"更改外部服务器的定义","BodyHTML":"\u003cpre\u003eALTER SERVER name [ VERSION \u0026#39;new_version\u0026#39; ]\n[ OPTIONS ( [ ADD | SET | DROP ] option [\u0026#39;value\u0026#39;] [, ... ] ) ]\nALTER SERVER name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\nALTER SERVER name RENAME TO new_name\u003c/pre\u003e\u003csection\u003e\u003ch2\u003e描述\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eALTER SERVER\u003c/code\u003e更改外部服务器的定义。第一种形式更改服务器的版本字符串或其通用选项（至少需要一个子句）。第二种形式更改服务器的拥有者。\u003c/p\u003e\u003cp\u003e要更改服务器，你必须是该服务器的拥有者。此外，要更改拥有者，你必须能够对新的拥有角色执行\u003ccode\u003eSET ROLE\u003c/code\u003e，并且必须在该服务器的外部数据包装器上具有\u003ccode\u003eUSAGE\u003c/code\u003e权限。（注意，超级用户会自动满足所有这些条件。）\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e参数\u003c/h2\u003e\u003cdiv\u003e\u003cdl\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e一个现有服务器的名称。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003enew_version\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e新服务器版本。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003ccode\u003eOPTIONS ( [ ADD | SET | DROP ] \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\u003e更改服务器的选项。\u003ccode\u003eADD\u003c/code\u003e、\u003ccode\u003eSET\u003c/code\u003e和 \u003ccode\u003eDROP\u003c/code\u003e指定要执行的动作。如果未显式指定操作，则假定为\u003ccode\u003eADD\u003c/code\u003e。选项名称必须唯一；名称和值也会使用该服务器的外部数据包装器库进行验证。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003enew_owner\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e该外部服务器的新拥有者的用户名。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e该外部服务器的新名称。\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e示例\u003c/h2\u003e\u003cp\u003e更改服务器\u003ccode\u003efoo\u003c/code\u003e，添加连接选项：\u003c/p\u003e\u003cpre\u003eALTER SERVER foo OPTIONS (host \u0026#39;foo\u0026#39;, dbname \u0026#39;foodb\u0026#39;);\n\u003c/pre\u003e\u003cp\u003e更改服务器\u003ccode\u003efoo\u003c/code\u003e，更改版本并修改 \u003ccode\u003ehost\u003c/code\u003e选项：\u003c/p\u003e\u003cpre\u003eALTER SERVER foo VERSION \u0026#39;8.4\u0026#39; OPTIONS (SET host \u0026#39;baz\u0026#39;);\n\u003c/pre\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e兼容性\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eALTER SERVER\u003c/code\u003e符合 ISO/IEC 9075-9 (SQL/MED)。\u003ccode\u003eOWNER TO\u003c/code\u003e和\u003ccode\u003eRENAME\u003c/code\u003e形式是 PostgreSQL 扩展。\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e另见\u003c/h2\u003e\u003cspan\u003e\u003ca href=\"/wiki/sql/create-server/?v=18\" title=\"CREATE SERVER\" rel=\"nofollow\"\u003e\u003cspan\u003eCREATE 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\u003c/span\u003e\u003c/section\u003e","SourceRevision":"1b5ca64c","ContentHash":"13a96918bf3ce727ceaad13256eee757efe5e44bb4f35ae366c9b859af7929dd","Payload":{"purpose_zh":"更改外部服务器的定义","sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER SERVER\u003c/code\u003e更改外部服务器的定义。第一种形式更改服务器的版本字符串或其通用选项（至少需要一个子句）。第二种形式更改服务器的拥有者。\u003c/p\u003e\u003cp\u003e要更改服务器，你必须是该服务器的拥有者。此外，要更改拥有者，你必须能够对新的拥有角色执行\u003ccode class=\"literal\"\u003eSET ROLE\u003c/code\u003e，并且必须在该服务器的外部数据包装器上具有\u003ccode class=\"literal\"\u003eUSAGE\u003c/code\u003e权限。（注意，超级用户会自动满足所有这些条件。）\u003c/p\u003e","key":"description","title":"描述"},{"html":"\u003cdiv class=\"variablelist\"\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e一个现有服务器的名称。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_version\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e新服务器版本。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eOPTIONS ( [ ADD | SET | DROP ] \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更改服务器的选项。\u003ccode class=\"literal\"\u003eADD\u003c/code\u003e、\u003ccode class=\"literal\"\u003eSET\u003c/code\u003e和 \u003ccode class=\"literal\"\u003eDROP\u003c/code\u003e指定要执行的动作。如果未显式指定操作，则假定为\u003ccode class=\"literal\"\u003eADD\u003c/code\u003e。选项名称必须唯一；名称和值也会使用该服务器的外部数据包装器库进行验证。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_owner\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e该外部服务器的新拥有者的用户名。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e该外部服务器的新名称。\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"参数"},{"html":"\u003cp\u003e更改服务器\u003ccode class=\"literal\"\u003efoo\u003c/code\u003e，添加连接选项：\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eALTER SERVER foo OPTIONS (host 'foo', dbname 'foodb');\n\u003c/pre\u003e\u003cp\u003e更改服务器\u003ccode class=\"literal\"\u003efoo\u003c/code\u003e，更改版本并修改 \u003ccode class=\"literal\"\u003ehost\u003c/code\u003e选项：\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eALTER SERVER foo VERSION '8.4' OPTIONS (SET host 'baz');\n\u003c/pre\u003e","key":"examples","title":"示例"},{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER SERVER\u003c/code\u003e符合 ISO/IEC 9075-9 (SQL/MED)。\u003ccode class=\"literal\"\u003eOWNER TO\u003c/code\u003e和\u003ccode class=\"literal\"\u003eRENAME\u003c/code\u003e形式是 PostgreSQL 扩展。\u003c/p\u003e","key":"compatibility","title":"兼容性"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/create-server/?v=18\" title=\"CREATE SERVER\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE 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\u003c/span\u003e","key":"see_also","title":"另见"}],"sections_same_as":"","synopsis_html":"ALTER SERVER \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e [ VERSION '\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_version\u003c/code\u003e\u003c/em\u003e' ]\n    [ OPTIONS ( [ ADD | SET | DROP ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e ['\u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e'] [, ... ] ) ]\nALTER SERVER \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e OWNER TO { \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_owner\u003c/code\u003e\u003c/em\u003e | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\nALTER SERVER \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e RENAME TO \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e","synopsis_text":"ALTER SERVER name [ VERSION 'new_version' ]\n[ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ]\nALTER SERVER name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\nALTER SERVER name RENAME TO new_name"}},"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}