This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
DEALLOCATE
Name
DEALLOCATE -- remove a prepared query
Synopsis
DEALLOCATE [ PREPARE ] plan_name
Inputs
- PREPARE
-
This keyword is ignored.
- plan_name
-
The name of the prepared query to remove.
Outputs
- DEALLOCATE
-
The prepared query was removed successfully.
Description
DEALLOCATE is used to remove a
previously prepared query. If you do not explicitly DEALLOCATE a prepared query, it is removed when
the session ends.
For more information on prepared queries, see PREPARE.
Compatibility
SQL92
SQL92 includes a DEALLOCATE
statement, but it is only for use in embedded SQL clients.