This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
version, or one of the other supported versions listed above instead.
DEALLOCATE -- remove a prepared query
DEALLOCATE [ PREPARE ] plan_name
This keyword is ignored.
The name of the prepared query to remove.
The prepared query was removed successfully.
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.
SQL92 includes a DEALLOCATE
statement, but it is only for use in embedded SQL clients.