man > ALTER_SERVER(7)

man perldoc info pydoc3 ri search

🏷️ NAME

ALTER SERVER — change the definition of a foreign server

🚀 Quick Reference

Use Case	Command	Description
Change server version	ALTER SERVER name VERSION 'new_version'	Update the version string of the foreign server.
Add connection options	ALTER SERVER name OPTIONS (ADD option 'value')	Add new options to the server.
Set an option	ALTER SERVER name OPTIONS (SET option 'value')	Modify an existing option’s value.
Drop an option	ALTER SERVER name OPTIONS (DROP option)	Remove an option from the server.
Change owner	ALTER SERVER name OWNER TO new_owner	Transfer ownership of the server.
Rename server	ALTER SERVER name RENAME TO new_name	Rename the foreign server.
Example: add connection options	ALTER SERVER foo OPTIONS (host 'foo', dbname 'foodb');	Add host and dbname options to server foo.
Example: change version and host	ALTER SERVER foo VERSION '8.4' OPTIONS (SET host 'baz');	Update version to 8.4 and set host to 'baz'.

📋 SYNOPSIS

ALTER SERVER name [ VERSION 'new_version' ]
    [ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ]
ALTER SERVER name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER SERVER name RENAME TO new_name

📝 DESCRIPTION

🔧 ALTER SERVER changes the definition of a foreign server. The first form changes the server version string or the generic options of the server (at least one clause is required). The second form changes the owner of the server.

🔑 To alter the server you must be the owner of the server. Additionally to alter the owner, you must own the server and also be a direct or indirect member of the new owning role, and you must have 📦 USAGE privilege on the server’s foreign‑data wrapper. (🦸 Note that superusers satisfy all these criteria automatically.)

⚙️ PARAMETERS

• 🏷️ name — The name of an existing server.
• 🆕 new_version — New server version string.
• ⚙️ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) — Change options for the server. ADD, SET, and DROP specify the action to be performed. ADD is assumed if no operation is explicitly specified. Option names must be unique; names and values are also validated using the server’s foreign‑data wrapper library.
• 🧑‍💼 new_owner — The user name of the new owner of the foreign server.
• 🏷️ new_name — The new name for the foreign server.

💡 EXAMPLES

🔗 Alter server foo, add connection options:

ALTER SERVER foo OPTIONS (host 'foo', dbname 'foodb');

🔄 Alter server foo, change version, and change the host option:

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

📜 COMPATIBILITY

📐 ALTER SERVER conforms to ISO/IEC 9075-9 (SQL/MED). The OWNER TO and RENAME forms are PostgreSQL extensions.

📚 SEE ALSO

🔧 CREATE SERVER(7) 🗑️ DROP SERVER(7)

📅 PostgreSQL 14.23 — 2026 — ALTER SERVER(7)

🏷️ NAME 🚀 Quick Reference 📋 SYNOPSIS 📝 DESCRIPTION ⚙️ PARAMETERS 💡 EXAMPLES 📜 COMPATIBILITY 📚 SEE ALSO