t
 Title: DEALLOCATE
 Author: The PostgreSQL Global Development Group
 Generator: DocBook XSL Stylesheets v1.79.1 <http://docbook.sf.net/>
 Date: 2021
 Manual: PostgreSQL 10.19 Documentation
 Source: PostgreSQL 10.19
 Language: English

 "DEALLOCATE" "7" "2021" "PostgreSQL 10.19" "PostgreSQL 10.19 Documentation"
 -----------------------------------------------------------------
 * Define some portability stuff
 -----------------------------------------------------------------
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 http://bugs.debian.org/507673
 http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 -----------------------------------------------------------------
 * set default formatting
 -----------------------------------------------------------------
 disable hyphenation
 disable justification (adjust text to left margin only)
 -----------------------------------------------------------------
 * MAIN CONTENT STARTS HERE *
 -----------------------------------------------------------------
 "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)