ALTER_SERVER(7pg14)

✨ ALTER SERVER ✨

okay so bestie, welcome to ALTER SERVER — the PostgreSQL 14.24 glow-up page for foreign servers 💅 this is where you change the definition of a foreign server, and yes it's as iconic as it sounds. (it's a section 7 page in the PostgreSQL 14.24 docs, if you're keeping track 🎀)

---

🌸 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. that's the whole vibe ✨

the first form changes the server version string or the generic options of the server — and heads up, at least one clause is required, you can't just send it an empty text and expect anything 🔥

the second form changes the owner of the server. new main character, same server 👑

to alter the server you must be the svr owner. and ooh, the owner-change is the strict one: 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. that's three whole vibe checks 😭 (but ngl, superusers satisfy all these criteria automatically — they're built different fr fr 🧚)

---

🦋 PARAMETERS 🦋

• name — the name of an existing server. like, one that already exists, don't come at me with a made-up name 🙈
• new_version — new server version. literally just the new version, slay.
• OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) — change options for the server. ADD, SET, and DROP specify the action to be performed, and ADD is assumed if no operation is explicitly specified (default behaviour, we love to see it ⭐). Option names must be unique — no duplicates bestie, that's not the move 💀 — and heads up, 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. fresh name, fresh era 🌈

---

🎀 EXAMPLES 🎀

Alter server foo, add connection options:

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

Alter server foo, change version, change host option:

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

see how clean that is?? obsessed 🫶

---

💀 COMPATIBILITY 💀

ALTER SERVER conforms to ISO/IEC 9075-9 (SQL/MED) — standards girlie behaviour 💅 but the OWNER TO and RENAME forms are PostgreSQL extensions, so that's us, being extra, as usual ✨

---

👑 SEE ALSO 👑

• CREATE SERVER (CREATE_SERVER(7))
• DROP SERVER (DROP_SERVER(7))

iykyk — go read those too, they're the whole friend group 🦋

---

and that's the page, bestie! brought to you by PostgreSQL 14.24, dated 2026 — periodt, go alter some servers 💜🌸