DROP_PUBLICATION(7pg14)

🎀 DROP_PUBLICATION 🎀

okay bestie, this is the DROP_PUBLICATION(7) page from the PostgreSQL 14.24 documentation, and it's literally about yeeting a publication out of your database. no cap, let's get into it. ✨💅

✨ NAME ✨

DROP_PUBLICATION — remove a publication 🫶

🌸 SYNOPSIS 🌸

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

💖 DESCRIPTION 💖

DROP PUBLICATION removes an existing publication from the database. that's the main character move here.

A publication can only be dropped by its owner or a superuser. so yeah, permissions check first, bestie — no random chaos allowed. 👑

🦋 PARAMETERS 🦋

• IF EXISTS — do not throw an error if the publication does not exist. A notice is issued in this case. so it's like, no dramatic error moment, just a lil heads-up. 🙈
• name — the name of an existing publication. literally the publication's name, bestie. 🎀
• CASCADE, RESTRICT — these key words do not have any effect, since there are no dependencies on publications. iconic do-nothing energy, honestly. 💀

🌈 EXAMPLES 🌈

Drop a publication:

DROP PUBLICATION mypublication;

⭐ COMPATIBILITY ⭐

DROP PUBLICATION is a PostgreSQL extension. periodt. 💅

👑 SEE ALSO 👑

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

---

okay that's the whole page!! brought to you by PostgreSQL 14.24 documentation, dated 2026 — page DROP PUBLICATION(7), signing off 💜🫶