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
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);