DEALLOCATE(7)

💖 NAME 💖

okay so bestie, welcome to DEALLOCATE(7) from the PostgreSQL 17.11 Documentation 💅 This page is literally about deallocating a prepared statement — like, saying bye-bye to it in the cleanest way possible 🫶

---

✨ SYNOPSIS ✨

DEALLOCATE [ PREPARE ] { name | ALL }

---

🌸 DESCRIPTION 🌸

DEALLOCATE is used to deallocate a previously prepared SQL statement. If you do not explicitly deallocate a prepared statement, it is deallocated when the session ends — no cap, session cleanup handles it 😭✨

For more information on prepared statements, see PREPARE(7). iykyk 🦋

---

🎀 PARAMETERS 🎀

• PREPARE — this key word is ignored. Yep, it’s just there doing nothing, bestie 💀
• name — the name of the prepared statement to deallocate. This is how you pick which one gets the goodbye 👋
• ALL — deallocate all prepared statements. not me clearing the whole group chat 🔥

---

🦋 COMPATIBILITY 🦋

The SQL standard includes a DEALLOCATE statement, but it is only for use in embedded SQL. So it’s giving standard-adjacent but with a very specific vibe, iykyk 💅

---

🌈 SEE ALSO 🌈

• EXECUTE(7)
• PREPARE(7)

---

That’s the whole page, bestie — brought to you by PostgreSQL 17.11, dated 2026 🎀✨💜