DROP_PUBLICATION(7)

💖 DROP_PUBLICATION 💖

okay bestie, gather round, because we're talking about DROP PUBLICATION — the PostgreSQL command that ✨yeets✨ a publication right out of your database. it's giving "cleanup era." no cap.

---

✨ SYNOPSIS ✨

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

---

🎀 DESCRIPTION 🎀

DROP PUBLICATION removes an existing publication from the database. gone. deleted. not invited to the group chat anymore. 💅

heads up bestie: a publication can only be dropped by its owner or a superuser. so if you're neither of those… it's not your moment, sorry. 😭

---

🌸 PARAMETERS 🌸

• IF EXISTS — do not throw an error if the publication doesn't exist. instead, a notice gets issued in this case. so chill, it's fine, no dramatic exit needed. 🫶
• name — the name of an existing publication. you know, the one you're about to send to the shadow realm. 👑
• CASCADE
• RESTRICT — okay so here's the tea: these key words do not have any effect, since there are no dependencies on publications. like, zero. they're just here vibing. they exist for the syntax to look cute and consistent. periodt. 💀

---

🦋 EXAMPLES 🦋

drop a publication:

DROP PUBLICATION mypublication;

that's it. that's the whole thing. she's gone. 🧚

---

⭐ COMPATIBILITY ⭐

DROP PUBLICATION is a PostgreSQL extension. it's our thing, iykyk. 🌈

---

💜 SEE ALSO 💜

• CREATE PUBLICATION (CREATE_PUBLICATION(7))
• ALTER PUBLICATION (ALTER_PUBLICATION(7))

---

and that's the whole manual page, bestie — you ate that. 🍓 this lil page came to you from PostgreSQL 18.6 documentation, dated 2026. slay, go drop some publications (responsibly). 💅✨