DROP_EXTENSION(7pg15)

✨ DROP EXTENSION 💅

okay so bestie, welcome to DROP EXTENSION — page 7 of the PostgreSQL 15.19 Documentation 🎀 this is the one where you say bye-bye to an extension, and honestly? it's giving cleanup era ✨

---

🌸 NAME 🌸

DROP EXTENSION — remove an extension 🫶

---

🦋 SYNOPSIS 🦋

DROP EXTENSION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

like, that's the whole vibe. copy it exactly, no cap 💅

---

💖 DESCRIPTION 💖

DROP EXTENSION removes extensions from the database. periodt. and here's the tea — dropping an extension causes its member objects, and other explicitly dependent routines (see ALTER ROUTINE (ALTER_ROUTINE(7)), the DEPENDS ON EXTENSION extension_name action) to be dropped as well. so yeah, they're going down with the ship 😭 no leaving anyone behind.

⚠️ also, bestie, you must own the extension to use DROP EXTENSION. no ownership, no dropping. rules are rules 👑

---

✨ PARAMETERS ✨

• IF EXISTS — do not throw an error if the extension does not exist. a notice is issued in this case. so instead of a whole dramatic meltdown, you just get a lil heads-up 🫶 very demure.
• name — the name of an installed extension. yup, that's the thing you're yeeting 🌈
• CASCADE — automatically drop objects that depend on the extension, and in turn all objects that depend on those objects (see Section 5.14). full domino effect, main character energy 🔥
• RESTRICT — this option prevents the specified extensions from being dropped if other objects, besides these extensions, their members, and their explicitly dependent routines, depend on them. this is the default. so chill, it's the safe mode 💀

---

💜 EXAMPLES 💜

to remove the extension hstore from the current database:

DROP EXTENSION hstore;

this command will fail if any of hstore's objects are in use in the database, for example if any tables have columns of the hstore type. add the CASCADE option to forcibly remove those dependent objects as well 😭 like yes it's dramatic but sometimes you gotta.

---

⭐ COMPATIBILITY ⭐

DROP EXTENSION is a PostgreSQL extension. iykyk 🌈

---

🎀 SEE ALSO 🎀

• CREATE EXTENSION (CREATE_EXTENSION(7))
• ALTER EXTENSION (ALTER_EXTENSION(7))

---

okay that's the whole page, you ate that 💅 go forth and drop responsibly. sending love from PostgreSQL 15.19, dated 2026 — DROP EXTENSION(7) and out 🦋✨🍓