DEALLOCATE

PostgreSQL 7.3.4 Documentation
PrevNext

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.

PrevHomeNext
CREATE VIEWUpDECLARE
Home
Online Resources
General
Beginner Tutorials
MySQL
PostgreSQL
Oracle
mSQL
Microsoft SQL
Contact Us
Random quote of the moment:
Confession is good for the soul only in the sense that a tweed coat is good for dandruff. -- Peter de Vries
 
http://www.sql.org/
 
Proudly designed and hosted by OmegaSphere, providers of all your Web Hosting, SSL Certificate, and Domain Name needs!