DROP_PUBLICATION(7pg15)

💅 DROP_PUBLICATION(7pg15) — PostgreSQL 15.19's "remove a publication" page 💅

okay so bestie, welcome to the DROP_PUBLICATION(7pg15) manual page from the PostgreSQL 15.19 Documentation ✨ this one is short, iconic, and fully about yeeting a publication out of the database. 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. literally its whole job 💅

and no cap, the permissions are strict: a publication can only be dropped by its owner or a superuser. that's the vibe check 👑

🦋 PARAMETERS 🦋

• IF EXISTS — do not throw an error if the publication does not exist. in that case, a notice is issued. so it's like "bestie, it's already gone" with a lil notice 💌
• name — the name of an existing publication. simple as that 🎀
• CASCADE, RESTRICT — okay so these key words do not have any effect, since there are no dependencies on publications. they're giving decorative 💀 you can include them, but they're not doing anything here.

🍓 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 bestie 🫶 this was PostgreSQL 15.19, dated 2026, from the DROP PUBLICATION(7) manual page — and yes, you just read the DROP_PUBLICATION(7pg15) version 💖 mwah 💋