DROP_TRANSFORM(7pg14)

hey bestie 💖 welcome to the DROP TRANSFORM(7) page, fresh from the PostgreSQL 14.24 Documentation ✨ today’s main character is DROP_TRANSFORM, and she is here to remove a transform. no cap, periodt. 💅

✨ NAME ✨

DROP_TRANSFORM — remove a transform. that’s the name, that’s the assignment, and honestly? iconic. 🎀

🦋 SYNOPSIS 🦋

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

🌸 DESCRIPTION 🌸

DROP_TRANSFORM removes a previously defined transform. lowkey straightforward, highkey powerful. ✨

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 yeah, same keys to the castle, bestie. 🔑

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the transform does not exist. a notice is issued in this case. so chill, it’s not gonna yell at you. 🙈
• 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.14). it’s giving “clean up the whole group chat.” 💀
• RESTRICT — refuse to drop the transform if any objects depend on it. this is the default. protective queen behavior, fr fr. 👑

🔥 EXAMPLES 🔥

say you wanna drop the transform for type hstore and language plpythonu — here’s the move, bestie:

DROP TRANSFORM FOR hstore LANGUAGE plpythonu;

⭐ COMPATIBILITY ⭐

This form of DROP TRANSFORM is a PostgreSQL extension. See CREATE TRANSFORM (CREATE_TRANSFORM(7)) for details. iykyk. 🫶

💜 SEE ALSO 💜

• CREATE TRANSFORM (CREATE_TRANSFORM(7))

---

mwah 💋 based on the PostgreSQL 14.24 docs, dated 2026, and it’s the DROP TRANSFORM(7) page. byeee, go be iconic with your transforms 🫶✨💅