DROP_PUBLICATION(7pg16)

💅 DROP PUBLICATION — the pg16 manual, bestie 💅

okay so welcome to DROP_PUBLICATION(7pg16), straight from the PostgreSQL 16.15 Documentation. this page is about removing a publication, and it is lowkey one of the most “bye bestie” commands in the whole database. no cap. 💖

🌸 NAME 🌸

DROP_PUBLICATION — remove a publication. simple, iconic, to the point. periodt.

✨ SYNOPSIS ✨

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

🦋 DESCRIPTION 🦋

DROP PUBLICATION removes an existing publication from the database. that's the whole vibe.

A publication can only be dropped by its owner or a superuser. so if you're neither, this command is not your main character moment 😭.

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the publication does not exist. a notice is issued in this case. lowkey considerate.
• name — the name of an existing publication. use the actual name, bestie 🫶
• CASCADE — does not have any effect, since there are no dependencies on publications.
• RESTRICT — does not have any effect, since there are no dependencies on publications.

🌈 EXAMPLES 🌈

Drop a publication:

DROP PUBLICATION mypublication;

ate. no crumbs. 🍓

⭐ COMPATIBILITY ⭐

DROP PUBLICATION is a PostgreSQL extension. iykyk.

👑 SEE ALSO 👑

• CREATE PUBLICATION (CREATE_PUBLICATION(7)) — the make-it-happen page ✨
• ALTER PUBLICATION (ALTER_PUBLICATION(7)) — the change-the-vibe page 💜

---

xoxo, this was the DROP PUBLICATION page from the PostgreSQL 16.15 documentation, dated 2026. stay hydrated, drop responsibly, and remember: the vibe changes, the facts do not 💖🎀🦋