ALTER SERVER

Synopsis

Use the ALTER SERVER command to alter the definition of a foreign server. The command can be used to alter the options of the foreign server, or to change its owner.

Syntax

Grammar
Diagram

alter_server ::= ALTER SERVER server_name [ VERSION server_version ]  
                 [ OPTIONS ( alter_fdw_options ) ] 
                 [ OWNER TO new_owner ]

alter_server

Semantics

Alter the foreign server named server_name.

Version

The VERSION clause can be used to specify the updated version of the server.

Options

The OPTIONS clause can be used to specify the new options of the foreign server. ADD, SET, and DROP specify the action to be performed. ADD is assumed if no operation is explicitly specified.

Examples

Change the server's version to 2.0, set opt1 to 'true', and drop opt2.

yugabyte=# ALTER SERVER my_server SERVER VERSION '2.0' OPTIONS (SET opt1 'true', DROP opt2);