DROP_SERVER(7pg14)

💅 DROP SERVER 💅

okay bestie, real talk — this is the DROP SERVER page from the PostgreSQL 14.24 docs (that's the DROP SERVER(7) man page, yes the whole manual-name thing, we're being fancy today ✨). It's short, it's sweet, and it's here to help you yeet a foreign server descriptor into the void. Let's get into it 🫶

---

🌸 NAME 🌸

DROP_SERVER — remove a foreign server descriptor

Like, literally just deletes it. Poof. Gone. Main character exit 💅

---

✨ SYNOPSIS ✨

DROP SERVER [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

That's the whole vibe right there. Note the [, ...] — yes queen, you can list multiple servers, the syntax said so 😌

---

🦋 DESCRIPTION 🦋

DROP SERVER removes an existing foreign server descriptor. That's the whole job description, no hidden lore.

Heads up though — to run this command, the current user must be the owner of the server. No ownership, no dropping. That's the rule, iykyk 🔥

---

🎀 PARAMETERS 🎀

• IF EXISTS — doesn't throw an error if the server doesn't exist. Instead it just issues a notice and moves on with its life. Very unbothered of it honestly 🙈
• name — the name of an existing server. You gotta actually name the thing you're dropping, bestie, we can't read your mind 💀
• CASCADE — automatically drops objects that depend on the server (such as user mappings), and then in turn all objects that depend on those objects. Yes, it cascades. Yes, it keeps going. See Section 5.14 for the full depend-o-rama. ⭐
• RESTRICT — refuses to drop the server if any objects depend on it. This is the default, so if you don't say anything, this is what you get. Polite, cautious, lowkey iconic 🌈

---

💖 EXAMPLES 💖

Drop a server foo if it exists:

DROP SERVER IF EXISTS foo;

That's it. That's the example. Chef's kiss 🤌

---

👑 COMPATIBILITY 👑

DROP SERVER conforms to ISO/IEC 9075-9 (SQL/MED). Standards girlie 💅

The IF EXISTS clause, however, is a PostgreSQL extension — i.e. our little bonus feature, not part of the standard. Ngl, we ate with that one 🍓

---

🌟 SEE ALSO 🌟

• CREATE SERVER (CREATE_SERVER(7))
• ALTER SERVER (ALTER_SERVER(7))

The full server lifecycle trilogy, fr fr 🧚

---

aaaand that's the page! 💜 this was DROP SERVER(7) from the PostgreSQL 14.24 documentation, dated 2026 — stay slaying, and remember: own the server before you drop the server 🎀✨