DROP_PUBLICATION(7pg13)

🌸 NAME 🌸

DROP_PUBLICATION — remove a publication. This is the DROP PUBLICATION(7) page from the PostgreSQL 13.23 Documentation, and yes bestie, we're keeping every fact while making it cute. ✨

🦋 SYNOPSIS 🦋

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

💖 DESCRIPTION 💖

So DROP PUBLICATION removes an existing publication from the database. That's the main-character move. 💅

Only the publication's owner or a superuser can drop it — no random group-chat lurker gets to delete stuff. 👑

🎀 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 “okay bestie, no drama, here's a lil notice.” 🙈
• name — the name of an existing publication. You gotta know which one you're dropping, iykyk. 🍓
• CASCADE — this key word does not have any effect, since there are no dependencies on publications. Lowkey decorative. 💀
• RESTRICT — this key word does not have any effect, since there are no dependencies on publications. Also lowkey decorative. 🫠

🌈 EXAMPLES 🌈

Drop a publication:

DROP PUBLICATION mypublication;

Ate. ✨

⭐ COMPATIBILITY ⭐

DROP PUBLICATION is a PostgreSQL extension. That's the whole compatibility note, bestie. 💜

👑 SEE ALSO 👑

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

💖 That's the whole page, bestie! This is the DROP PUBLICATION(7) manual from PostgreSQL 13.23, dated 2025. Go forth and drop publications responsibly! 🎀🦋