DROP_TABLESPACE(7pg15)

💅 DROP_TABLESPACE — the "bye bestie" page for tablespaces ✨

okay so real talk: this is the DROP TABLESPACE page from the PostgreSQL 15.19 Documentation (yes, the 7pg15 one, you found it 🫶). It's short, it's sweet, and it's giving "cleanup era." Let's get into it 🌸

---

✨ NAME ✨

DROP TABLESPACE — literally just remove a tablespace. that's the whole vibe. 🎀

---

🦋 SYNOPSIS 🦋

DROP TABLESPACE [ IF EXISTS ] name

look at her. so compact. so powerful. 👑

---

💖 DESCRIPTION 💖

DROP TABLESPACE removes a tablespace from the system. periodt. 💅

Now the important bits, bestie, don't skip these:

• Only the owner of the tablespace or a superuser can drop it. so like, know your lane 🙈
• The tablespace must be empty of all database objects before it can be dropped. no objects, no problem. objects = blocked.
• Sneaky detail: it's possible that objects in other databases might still reside in the tablespace even if no objects in the current database are using it. so it can look empty from where you're standing and still not be. the audacity 😭
• Also — and this one gets people — if the tablespace is listed in the temp_tablespaces setting of any active session, the DROP might fail because of temporary files residing in the tablespace. temp files said "we live here now" 💀

---

🍓 PARAMETERS 🍓

• IF EXISTS — do not throw an error if the tablespace does not exist. instead a notice is issued in this case. very "no harm no foul" of it 💜
• name — the name of a tablespace. that's it, that's the parameter. simple icon behavior ✨

---

🔥 NOTES 🔥

DROP TABLESPACE cannot be executed inside a transaction block. nope. not happening. don't even try it 🚫

---

🌈 EXAMPLES 🌈

To remove tablespace mystuff from the system:

DROP TABLESPACE mystuff;

bye mystuff 👋 you had a good run, bestie 🦋

---

👑 COMPATIBILITY 👑

DROP TABLESPACE is a PostgreSQL extension. so like, this is our thing, iykyk 💅

---

🌸 SEE ALSO 🌸

• CREATE TABLESPACE (CREATE_TABLESPACE(7)) — the making-her era
• ALTER TABLESPACE (ALTER_TABLESPACE(7)) — the glow-up era

---

and that's the page!! mwah 💖 this was PostgreSQL 15.19, dated 2026 — go drop those tablespaces responsibly, and remember: empty it first, no transaction blocks, and check your other databases before you commit to the goodbye 😭🫶✨