DROP_PUBLICATION(7pg17)

💖 NAME 💖

DROP_PUBLICATION — remove a publication, periodt 💅

This is the DROP_PUBLICATION page from the PostgreSQL 17.11 Documentation, manual section 7. okay bestie, let’s get into it 🦋

---

✨ SYNOPSIS ✨

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

---

🦋 DESCRIPTION 🦋

okay so 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 yeah, permissions matter, no cap 👑

---

🌸 PARAMETERS 🌸

• IF EXISTS — don’t throw an error if the publication does not exist. A notice is issued in this case. it’s giving “no drama, just a lil heads-up” ✨
• name — the name of an existing publication. yes bestie, it’s an existing one, iykyk 💅
• CASCADE, RESTRICT — these key words do not have any effect, since there are no dependencies on publications. literally zero effect, don’t stress 🫶

---

🔥 EXAMPLES 🔥

Drop a publication:

DROP PUBLICATION mypublication;

slay, that’s it 💅

---

🌈 COMPATIBILITY 🌈

DROP PUBLICATION is a PostgreSQL extension. so it’s a Postgres-only flex 💜

---

👑 SEE ALSO 👑

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

---

mwah 💋 — source/version: PostgreSQL 17.11, date: 2026. DROP PUBLICATION(7) out. 🎀