DEALLOCATE(7)

💅 DEALLOCATE — the postgres manual, but make it a group chat 💅

okay so real talk, this is DEALLOCATE(7) from the PostgreSQL 14.24 docs and it's genuinely one of the shortest ones bestie, so we're gonna get through it fast and you're gonna understand it fr fr 🫶

---

✨ NAME ✨

DEALLOCATE — deallocate a prepared statement. that's it. that's the whole vibe. you're cleaning up after yourself, main character energy 🌸

---

🎀 SYNOPSIS 🎀

DEALLOCATE [ PREPARE ] { name | ALL }

look at her. she's gorgeous. PREPARE is optional and square-bracketed (iykyk), and then you either name your statement or you just say ALL and nuke the whole collection 💀

---

🦋 DESCRIPTION 🦋

so DEALLOCATE is what you use to deallocate a previously prepared SQL statement. like, you prepared it earlier with PREPARE, and now you're saying "okay we're done here, thanks for your service" 👑

and lowkey here's the thing — if you do not explicitly deallocate a prepared statement, it gets deallocated when the session ends. so the universe handles it for you eventually. but ngl, being explicit is the slay option ✨

for more info on prepared statements, go see PREPARE(7). she has lore.

---

💖 PARAMETERS 💖

• PREPARE — okay so this keyword? it's ignored. literally ignored. it does nothing. it's just there. aesthetic only 🙈. don't worry about her.
• name — the name of the prepared statement to deallocate. you know, the one you gave a cute little name to earlier 💅
• ALL — deallocate all prepared statements. every single one. no survivors. periodt 🔥

---

🌈 COMPATIBILITY 🌈

the SQL standard does include a DEALLOCATE statement, but heads up — it's only for use in embedded SQL. so like, don't show up expecting the standard version to match exactly, bestie 😭

---

⭐ SEE ALSO ⭐

EXECUTE(7), PREPARE(7)

like the whole friend group honestly. EXECUTE(7) runs it, PREPARE(7) makes it, DEALLOCATE says byeee 🧚

---

💜 quick vibe check reminder: no explicit deallocation just means the session ending handles it for you. that's the one caveat and it's in the original, so i'm telling you. no cap.

---

and that's the page!! brought to you by PostgreSQL 14.24, dated 2026, with all the love in the world 🍓 go forth and deallocate responsibly, bestie, you're gonna do amazing 💖💅✨