1DEALLOCATE(7)            PostgreSQL 12.2 Documentation           DEALLOCATE(7)
2
3
4

NAME

6       DEALLOCATE - deallocate a prepared statement
7

SYNOPSIS

9       DEALLOCATE [ PREPARE ] { name | ALL }
10

DESCRIPTION

12       DEALLOCATE is used to deallocate a previously prepared SQL statement.
13       If you do not explicitly deallocate a prepared statement, it is
14       deallocated when the session ends.
15
16       For more information on prepared statements, see PREPARE(7).
17

PARAMETERS

19       PREPARE
20           This key word is ignored.
21
22       name
23           The name of the prepared statement to deallocate.
24
25       ALL
26           Deallocate all prepared statements.
27

COMPATIBILITY

29       The SQL standard includes a DEALLOCATE statement, but it is only for
30       use in embedded SQL.
31

SEE ALSO

33       EXECUTE(7), PREPARE(7)
34
35
36
37PostgreSQL 12.2                      2020                        DEALLOCATE(7)
Impressum