ALTER SERVER
ALTER SERVER — change the definition of a foreign server
Synopsis
ALTER SERVERname[ VERSION 'new_version' ] [ OPTIONS ( [ ADD | SET | DROP ]option['value'] [, ... ] ) ]ALTER SERVERnameOWNER TO {new_owner| CURRENT_ROLE | CURRENT_USER | SESSION_USER }ALTER SERVERnameRENAME TOnew_name
Description
ALTER SERVER 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.
To alter the server you must be the owner of the server. Additionally to alter the owner, you must be able toSET ROLE to the new owning role, and you must haveUSAGE privilege on the server's foreign-data wrapper. (Note that superusers satisfy all these criteria automatically.)
Parameters
nameThe name of an existing server.
new_versionNew server version.
OPTIONS ( [ ADD | SET | DROP ]option['value'] [, ... ] )Change options for the server.
ADD,SET, andDROPspecify the action to be performed.ADDis 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.new_ownerThe user name of the new owner of the foreign server.
new_nameThe new name for the foreign server.
Examples
Alter serverfoo, add connection options:
ALTER SERVER foo OPTIONS (host 'foo', dbname 'foodb');
Alter serverfoo, change version, changehost option:
ALTER SERVER foo VERSION '8.4' OPTIONS (SET host 'baz');
Compatibility
ALTER SERVER conforms to ISO/IEC 9075-9 (SQL/MED). TheOWNER TO andRENAME forms are PostgreSQL extensions.