Mastering PostgreSQL 12 - Third Edition

Handling mistakes and typos

Creating foreign tables isn't really hard—however, it sometimes happens that people make mistakes, or maybe the passwords that have been used simply change. To handle such issues, PostgreSQL offers two commands: ALTER SERVER and ALTER USER MAPPING.

ALTER SERVER allows you to modify a server:

test=# \h ALTER SERVER Command:  ALTER SERVERDescription: change the definition of a foreign serverSyntax: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_nameURL: https://www.postgresql.org/docs/12/sql-alterserver.html

We can use this command to add and remove options ...