DROP_LANGUAGE(7pg14)

💅 DROP_LANGUAGE (7pg14) — the "bye bestie" command for procedural languages ✨

okay so real talk, this is the DROP LANGUAGE page from the PostgreSQL 14.24 docs and it's honestly such a mood: it's the command that removes a procedural language you (or someone) registered earlier. Let's get into it 🫶

---

🌸 NAME 🌸

DROP_LANGUAGE — remove a procedural language. literally just yeeting the definition of it, no cap.

---

🎀 SYNOPSIS 🎀

DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ]

look at her go 💅 everything in brackets is optional, so you can keep it minimal or go full main character with all the bells and whistles.

---

🦋 DESCRIPTION 🦋

DROP LANGUAGE removes the definition of a previously registered procedural language. it's giving "cleanup era" honestly ✨

⚠️ permission check, bestie: you must be a superuser or the owner of the language to use DROP LANGUAGE. no exceptions, no vibes-based access.

📌 Note: as of PostgreSQL 9.1, most procedural languages have been made into "extensions", and should therefore be removed with DROP EXTENSION — not DROP LANGUAGE. so like… check before you yeet, iykyk 🙈

---

✨ PARAMETERS ✨

• IF EXISTS — do not throw an error if the language does not exist. a notice is issued in this case. it's the "no drama" flag, she just shrugs and moves on 🧚
• name — the name of an existing procedural language. the actual target of your un-registration era 🎯
• CASCADE — automatically drop objects that depend on the language (such as functions in the language), and in turn all objects that depend on those objects (see Section 5.14). chain reaction, very domino-effect of her 💀
• RESTRICT — refuse to drop the language if any objects depend on it. this is the default. she's cautious, she's responsible, she's the group-chat mom 🌈

---

🔥 EXAMPLES 🔥

this command removes the procedural language plsample:

DROP LANGUAGE plsample;

ate. no crumbs. bye plsample 👑

---

💜 COMPATIBILITY 💜

there is no DROP LANGUAGE statement in the SQL standard. so yeah, this one's a PostgreSQL original — icon behavior, honestly ⭐

---

💖 SEE ALSO 💖

• ALTER LANGUAGE (ALTER_LANGUAGE(7))
• CREATE LANGUAGE (CREATE_LANGUAGE(7))

like, if you're dropping her you should at least know her whole lore 🫶

---

🌸 that's the whole page, bestie — go forth and un-register responsibly 🌸

sign-off tingz 🎀: this was the PostgreSQL 14.24 documentation, dated 2026, and the page itself is DROP LANGUAGE(7). mwah 💋