DROP_TRANSFORM(7pg13)

💅 DROP_TRANSFORM 💅

ok so bestie, welcome to DROP TRANSFORM(7) — straight outta the PostgreSQL 13.23 Documentation. this is the page where we learn how to yeet a transform into the void. let's get into it 🫶

---

✨ NAME ✨

DROP_TRANSFORM — remove a transform. that's it. that's the whole vibe. 💀

---

🌸 SYNOPSIS 🌸

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

like, look at her. so clean. so structured. main character energy fr fr 👑

---

🦋 DESCRIPTION 🦋

DROP TRANSFORM removes a previously defined transform. that's the whole job, and honestly? she ate. ✨

but okay, plot twist — there's a vibe check before you can drop one: you must own the type and the language. yep, both. these are literally the same privileges you'd need to create a transform in the first place, so if you built it, you can destroy it. no cap. 🔥

---

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the transform does not exist. instead, a notice is issued in this case. so it's like, nice about it. 🥺
• type_name — the name of the data type of the transform. iykyk 🧚
• 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.14). it's giving chain reaction, lowkey iconic 🌈
• RESTRICT — refuse to drop the transform if any objects depend on it. this is the default. she's cautious. she's careful. she's protecting you from yourself 🙈

⚠️ okay so real talk: that CASCADE situation is not a drill. it takes out everything that depends on the transform, and then everything depending on those objects. read Section 5.14 before you go feral with it, bestie 💀

---

🌟 EXAMPLES 🌟

so if you wanted to drop the transform for type hstore and language plpythonu, you'd literally just do this:

DROP TRANSFORM FOR hstore LANGUAGE plpythonu;

periodt. done. slay. 💅

---

⭐ COMPATIBILITY ⭐

this form of DROP TRANSFORM is a PostgreSQL extension. so like, don't expect other databases to get the assignment 😭 see CREATE TRANSFORM (CREATE_TRANSFORM(7)) for details.

---

🍓 SEE ALSO 🍓

• CREATE TRANSFORM (CREATE_TRANSFORM(7))

---

okay that's the whole page, bestie! go forth and drop responsibly 🦋

sign-off city: this was PostgreSQL 13.23, dated 2025, and the title is DROP TRANSFORM(7) — mwah, love u, bye 💖🎀✨