DEALLOCATE(7)

💅 DEALLOCATE(7) 💅

okay bestie, welcome to the DEALLOCATE(7) page from the PostgreSQL 16.15 Documentation ✨ this one is short, sweet, and here to help you clean up your prepared statements 🎀

---

🎀 NAME 🎀

DEALLOCATE — deallocate a prepared statement 🫶

✨ SYNOPSIS ✨

DEALLOCATE [ PREPARE ] { name | ALL }

🌸 DESCRIPTION 🌸

DEALLOCATE is literally the command you use to deallocate a previously prepared SQL statement 💖 it's giving cleanup era, no cap.

If you do not explicitly deallocate a prepared statement, it gets deallocated when the session ends 👑 so like, it won't just vibe forever.

For more info on prepared statements, go peek at PREPARE(7) 🦋

💜 PARAMETERS 💜

• PREPARE — this key word is ignored 🙈 yes, bestie, it's just there and PostgreSQL is unbothered.
• name — the name of the prepared statement you want to deallocate 🎀
• ALL — deallocate all prepared statements 🔥 all of them, periodt.

🌈 COMPATIBILITY 🌈

The SQL standard includes a DEALLOCATE statement, but it is only for use in embedded SQL 💅 so that's the compatibility tea.

⭐ SEE ALSO ⭐

EXECUTE(7), PREPARE(7) 🧚 go check those out too, iykyk.

---

mwah 💋 signed, sealed, and slayed: PostgreSQL 16.15, dated 2026, page DEALLOCATE(7) 💖✨