DROP_TRANSFORM(7pg16)

💅 DROP_TRANSFORM(7pg16) — the glow-up where transforms get ✨removed✨

okay bestie, so you know how this is the PostgreSQL 16 docs situation? this page is literally the DROP TRANSFORM page and it's here to tell you how to yeet a transform out of existence. no cap, it's a short one, we love a concise icon 💖

---

🦋 NAME

DROP_TRANSFORM — remove a transform, periodt.

---

🌸 SYNOPSIS

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

look at her. she's short, she's iconic, she's the whole vibe check 🎀

---

✨ DESCRIPTION

so DROP TRANSFORM removes a previously defined transform. that's the whole assignment, bestie 💅

but here's the tea: to be able to drop a transform, you must own the type and the language. these are the same privileges that are required to create a transform. so like... you gotta have the keys to both houses, iykyk 🔑

---

💖 PARAMETERS

• IF EXISTS — do not throw an error if the transform does not exist. a notice is issued in this case. so instead of a whole dramatic meltdown 💀 you just get a little "hey, it wasn't there" note. very demure, very mindful.
• type_name — the name of the data type of the transform. like, which type are we talking about, bestie?
• lang_name — the name of the language of the transform. the language part of the situation 🌈
• 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 domino effect, it's giving "and then everything that touched that also goes" 🔥 careful with this one, she's powerful.
• RESTRICT — refuse to drop the transform if any objects depend on it. this is the default. so by default she's not gonna let you wreck the whole ecosystem, she's gonna say no 🙈

---

🧚 EXAMPLES

to drop the transform for type hstore and language plpython3u:

DROP TRANSFORM FOR hstore LANGUAGE plpython3u;

slay, and it's gone 💫

---

👑 COMPATIBILITY

this form of DROP TRANSFORM is a PostgreSQL extension. see CREATE TRANSFORM (CREATE_TRANSFORM(7)) for details. so like, don't expect other databases to have this exact vibe, it's a Postgres original 🫶

---

🍓 SEE ALSO

CREATE TRANSFORM (CREATE_TRANSFORM(7)) — the birth, if you will ✨

---

and that's the whole page bestie!! 🎀 this little icon lives in the PostgreSQL 16.15 docs, dated 2026, and it's filed under DROP TRANSFORM(7). go forth and drop responsibly 💜