This page in other versions: 9.1 / 9.2 / 9.3 / 9.4 / current (9.5)  |  Development versions: devel / 9.6  |  Unsupported versions: 7.3 / 7.4 / 8.0 / 8.1 / 8.2 / 8.3 / 8.4 / 9.0

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.

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Privacy Policy | About PostgreSQL
Copyright © 1996-2016 The PostgreSQL Global Development Group