DEALLOCATE(7) PostgreSQL 14.19 Documentation DEALLOCATE(7)
NAME
DEALLOCATE - deallocate a prepared statement
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.
For more information on prepared statements, see PREPARE(7).
PARAMETERS
PREPARE
This key word is ignored.
name
The name of the prepared statement to deallocate.
ALL
Deallocate all prepared statements.
COMPATIBILITY
The SQL standard includes a DEALLOCATE statement, but it is only for use in embedded SQL.
SEE ALSO
EXECUTE(7), PREPARE(7)
PostgreSQL 14.19 2025 DEALLOCATE(7)
Generated by $Id: phpMan.php,v 4.55 2007/09/05 04:42:51 chedong Exp $ Author: Che Dong
On Apache
Under GNU General Public License
2025-11-22 19:20 @216.73.216.63 CrawledBy Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)