DEALLOCATE(7)

💅 DEALLOCATE(7) — deallocate a prepared statement ✨

okay so this is the DEALLOCATE(7) page from the PostgreSQL 13.23 Documentation, and it’s literally about cleaning up prepared statements. no cap. 🧹

🌸 NAME 🌸

DEALLOCATE — deallocate a prepared statement 💅

✨ SYNOPSIS ✨

DEALLOCATE [ PREPARE ] { name | ALL }

🦋 DESCRIPTION 🦋

okay bestie, DEALLOCATE is how you deallocate a previously prepared SQL statement. if you don’t explicitly deallocate a prepared statement, it is deallocated when the session ends. periodt. 💖

for more information on prepared statements, go see PREPARE(7) ✨.

🎀 PARAMETERS 🎀

• PREPARE — this key word is ignored. yep, it’s just there, living its life. 🙈
• name — the name of the prepared statement to deallocate. 💅
• ALL — deallocate all prepared statements. all of them. the whole roster. 👑

💀 COMPATIBILITY 💀

the SQL standard includes a DEALLOCATE statement, but it is only for use in embedded SQL. that’s the vibe check. ✨

🌈 SEE ALSO 🌈

EXECUTE(7), PREPARE(7)

💖 okay that’s the whole page, bestie — this iconic little manual page is brought to you by PostgreSQL 13.23, dated 2025. slay. 🫶