DROP_TABLESPACE(7pg16)

🌸 NAME 🌸

okay bestie, this is the DROP TABLESPACE(7) page from the PostgreSQL 16 docs — the whole vibe is remove a tablespace. 💅

---

✨ SYNOPSIS ✨

DROP TABLESPACE [ IF EXISTS ] name

---

🫶 DESCRIPTION 🫶

DROP TABLESPACE removes a tablespace from the system. no cap, that's the main character move. ✨

Only the tablespace's owner or a superuser can drop it. The tablespace must be empty of all database objects before it can be dropped — literally all of them, bestie. 🫶

And heads up: objects in other databases might still reside in the tablespace even if no objects in the current database are using it. also, if the tablespace is listed in the temp_tablespaces setting of any active session, the DROP might fail due to temporary files residing in the tablespace. 😭

---

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the tablespace does not exist. a notice is issued in this case. so polite, honestly. 🎀
• name — the name of a tablespace. simple as that. 💖

---

🔥 NOTES 🔥

DROP TABLESPACE cannot be executed inside a transaction block. periodt. 🔥

---

🌈 EXAMPLES 🌈

to remove tablespace mystuff from the system:

DROP TABLESPACE mystuff;

iconic. clean. very demure. ✨

---

👑 COMPATIBILITY 👑

DROP TABLESPACE is a PostgreSQL extension. 👑

---

🦋 SEE ALSO 🦋

• CREATE TABLESPACE (CREATE_TABLESPACE(7))
• ALTER TABLESPACE (ALTER_TABLESPACE(7))

---

mwah 💋 — this one comes from PostgreSQL 16.15, dated 2026. xoxo, go drop that tablespace responsibly. 💖