DROP_TRANSFORM(7pg15)

💅 DROP_TRANSFORM

ok so this is the PostgreSQL 15.19 page for DROP_TRANSFORM — it lives in section 7 of the manual, bestie, and it's literally your how-to for yeeting a transform out of existence 🦋

---

✨ NAME ✨

DROP_TRANSFORM — remove a transform. that's it. that's the whole vibe. poof, gone, no cap 💀

---

🌸 SYNOPSIS 🌸

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

look at her. so clean. so powerful. so main character 👑

---

🎀 DESCRIPTION 🎀

ok so DROP TRANSFORM removes a previously defined transform. like, one that already exists. you're not creating anything here, you're doing the opposite — you're the one holding the metaphorical trash bag 🗑️✨

and here's the part where you gotta have the right credentials, because PostgreSQL does NOT play:

• to be able to drop a transform, you must own the type and the language.
• and yeah — these are the same privileges that are required to create a transform. iconic symmetry, honestly. same keys, same doors 🔑

---

💖 PARAMETERS 💖

• IF EXISTS — do not throw an error if the transform does not exist. a notice is issued in this case. so like, if the thing's already gone, Postgres is just gonna be like "mmkay noted" instead of screaming at you 😌
• type_name — the name of the data type of the transform. the type. the one the transform is for. you got this 🫶
• lang_name — the name of the language of the transform. the language. also the one the transform is for. matching set, bestie 🌈
• 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. it's giving dominoes. proceed with intention, babes 🔥
• RESTRICT — refuse to drop the transform if any objects depend on it. this is the default. she's cautious. she's protective. she's the responsible friend who holds your phone at parties 💅

---

🧚 EXAMPLES 🧚

to drop the transform for type hstore and language plpython3u:

DROP TRANSFORM FOR hstore LANGUAGE plpython3u;

ate. no crumbs. 🍓

---

⭐ COMPATIBILITY ⭐

this form of DROP TRANSFORM is a PostgreSQL extension. see CREATE TRANSFORM (CREATE_TRANSFORM(7)) for details. so like, not standard SQL — this is a Postgres original, iykyk 👑

---

🦋 SEE ALSO 🦋

• CREATE TRANSFORM (CREATE_TRANSFORM(7))

---

💜 real talk: CASCADE is the loud one and RESTRICT is the default for a reason — check what's depending on your transform before you go dropping things, fr fr.

---

ok that's the whole page, bestie — go forth and drop responsibly 💅✨

this was PostgreSQL 15.19 documentation, dated 2026 — DROP_TRANSFORM(7), signing off 🎀💖