top of page
CerebroSQL

PostgreSQL:  

ALTER SERVER

ALTER SERVER server_name [ VERSION 'new_version' ]
[ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ]
ALTER SERVER server_name OWNER TO new_owner

Example

ALTER SERVER foo OPTIONS (host 'foo', dbname 'foodb');
ALTER SERVER foo VERSION '8.4' OPTIONS (SET host 'baz');

bottom of page