DROP_SERVER(7pg17)

πŸ“¦ version 17.11, in opensuse-leap 16.0

πŸ’… NAME πŸ’…

okay so this is literally the DROP_SERVER page, bestie β€” manual name DROP SERVER(7), from the PostgreSQL 17.11 Documentation. And the vibe? DROP_SERVER β€” remove a foreign server descriptor. That's the whole assignment. ✨

✨ SYNOPSIS ✨

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

πŸ’… DESCRIPTION πŸ’…

Okay so DROP SERVER removes an existing foreign server descriptor. To execute this command, the current user must be the owner of the server. Owner check is real β€” no cap. πŸ‘‘

πŸŽ€ PARAMETERS πŸŽ€

  • IF EXISTS β€” do not throw an error if the server does not exist. A notice is issued in this case. So like, no dramatic crash, just a little notice. 🫢
  • name β€” the name of an existing server. literally the server's name, bestie.
  • CASCADE β€” automatically drop objects that depend on the server (such as user mappings), and in turn all objects that depend on those objects (see Section 5.15). it's giving chain reaction. πŸ”₯
  • RESTRICT β€” refuse to drop the server if any objects depend on it. This is the default. so if you don't pick, it's restrictive by default. periodt. πŸ’…

πŸ¦‹ EXAMPLES πŸ¦‹

Drop a server foo if it exists:

DROP SERVER IF EXISTS foo;

like the example says, bestie. clean, simple, iconic. ✨

⭐ COMPATIBILITY ⭐

DROP SERVER conforms to ISO/IEC 9075-9 (SQL/MED). The IF EXISTS clause is a PostgreSQL extension. so yes, standard with a little PostgreSQL extra sparkle. 🌈

🌈 SEE ALSO 🌈


that's the page, bestie πŸ’– Source/version + date vibes: PostgreSQL 17.11, 2026, and the footer says DROP SERVER(7). go off, queen πŸ‘‘βœ¨

πŸ“¦ where this page comes from