DROP_TRANSFORM(7pg17)

💅 DROP TRANSFORM 💅

okay so real talk: this is a 7pg17 manual page (PostgreSQL 17 docs bestie, we're in the big leagues) and it's all about yeeting a transform out of your database. let's get into it 🫶

---

✨ SYNOPSIS ✨

DROP TRANSFORM [ IF EXISTS ] FOR type_name LANGUAGE lang_name [ CASCADE | RESTRICT ]

that's the whole vibe. one line, one job, zero drama 🌸

---

🦋 DESCRIPTION 🦋

DROP TRANSFORM removes a previously defined transform. like, gone. poof. no cap ✨

but here's the part you actually need to know, bestie: to be able to drop a transform, you must own the type and the language. both of them. these are the same privileges that are required to create a transform — so if you could make it, you can break it. iconic symmetry, honestly 💅

---

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the transform does not exist. a notice is issued in this case. so like, it's the "no worries if not" of parameters 🫶
• type_name — the name of the data type of the transform.
• lang_name — the name of the language of the transform.
• CASCADE — automatically drop objects that depend on the transform, and in turn all objects that depend on those objects (see Section 5.15). it's giving domino effect 😭🔥
• RESTRICT — refuse to drop the transform if any objects depend on it. this is the default. so if you don't say anything, it's gonna be all protective and say "nope, something needs me" 💀

⚠️ heads up: CASCADE is the unhinged option. it takes down everything downstream. sure, slay, but know what you're doing before you type it 🧚

---

🌈 EXAMPLES 🌈

to drop the transform for type hstore and language plpython3u:

DROP TRANSFORM FOR hstore LANGUAGE plpython3u;

see? short. sweet. ate and left no crumbs 👑

---

⭐ COMPATIBILITY ⭐

this form of DROP TRANSFORM is a PostgreSQL extension. for the tea, see CREATE TRANSFORM (CREATE_TRANSFORM(7)) for details. it's not standard SQL, it's our thing, iykyk 💜

---

💖 SEE ALSO 💖

• CREATE TRANSFORM (CREATE_TRANSFORM(7))

---

and that's the whole page, bestie! 🎀 this little gem comes to you from PostgreSQL 17.11, dated 2026 — DROP TRANSFORM(7), signing off. go forth and drop responsibly, mwah 💋🌸