2
doc/src/sgml/ref/deallocate.sgml
3
PostgreSQL documentation
6
<refentry id="SQL-DEALLOCATE">
8
<refentrytitle>DEALLOCATE</refentrytitle>
9
<manvolnum>7</manvolnum>
10
<refmiscinfo>SQL - Language Statements</refmiscinfo>
14
<refname>DEALLOCATE</refname>
15
<refpurpose>deallocate a prepared statement</refpurpose>
18
<indexterm zone="sql-deallocate">
19
<primary>DEALLOCATE</primary>
22
<indexterm zone="sql-deallocate">
23
<primary>prepared statements</primary>
24
<secondary>removing</secondary>
29
DEALLOCATE [ PREPARE ] { <replaceable class="parameter">name</replaceable> | ALL }
34
<title>Description</title>
37
<command>DEALLOCATE</command> is used to deallocate a previously
38
prepared SQL statement. If you do not explicitly deallocate a
39
prepared statement, it is deallocated when the session ends.
43
For more information on prepared statements, see <xref
44
linkend="sql-prepare">.
49
<title>Parameters</title>
53
<term><literal>PREPARE</literal></term>
56
This key word is ignored.
62
<term><replaceable class="parameter">name</replaceable></term>
65
The name of the prepared statement to deallocate.
71
<term><literal>ALL</literal></term>
74
Deallocate all prepared statements.
82
<title>Compatibility</title>
85
The SQL standard includes a <command>DEALLOCATE</command>
86
statement, but it is only for use in embedded SQL.
91
<title>See Also</title>
93
<simplelist type="inline">
94
<member><xref linkend="sql-execute"></member>
95
<member><xref linkend="sql-prepare"></member>