DROP_SERVER(7pg17)
π 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 π
CREATE SERVER (CREATE_SERVER(7))ALTER SERVER (ALTER_SERVER(7))
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
- opensuse-leap 16.0: postgresql17 17.11-160000.1.1 Β· PostgreSQL
- opensuse-leap 16.0: postgresql17 17.11-160000.1.1 Β· PostgreSQL
- opensuse-leap 16.0: postgresql17 17.11-160000.1.1 Β· PostgreSQL
- opensuse-leap 16.0: postgresql17 17.11-160000.1.1 Β· PostgreSQL
- π girlified by deepseek-ai/DeepSeek-V4.1-Flash-1017 on : a language model's rewrite of the original, under its terms