Mastering PostgreSQL 9.6

Handling mistakes and typos

Creating foreign tables is not really hard--however, it sometimes happens that people make mistakes, or maybe the passwords used simply change. To handle such issues, PostgreSQL offers two commands.

ALTER SERVER allows you to modify a server:

test=# \h ALTER SERVER Command:     ALTER SERVER Description: change the definition of a foreign server Syntax: ALTER SERVER name [ VERSION 'new_version' ]     [ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ] ALTER SERVER name OWNER TO { new_owner | CURRENT_USER | SESSION_USER } ALTER SERVER name RENAME TO new_name 

You can use this command to add and remove options for a specific server, which is a good thing in case you have forgotten something.

If you want to modify ...