PostgreSQL :: Tecnisys Docs

DEALLOCATE
Prev	Up	SQL Commands	Home	Next

DEALLOCATE

DEALLOCATE — deallocate a prepared statement

Synopsis

DEALLOCATE [ PREPARE ] { name | ALL }

Description

DEALLOCATE is used to deallocate a previously prepared SQL statement. If you do not explicitly deallocate a prepared statement, it is deallocated when the session ends.

For more information on prepared statements, see PREPARE.

Parameters

PREPARE: This key word is ignored.
`name`: The name of the prepared statement to deallocate.
ALL: Deallocate all prepared statements.

Compatibility

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

Prev	Up	Next
CREATE VIEW	Home	DECLARE

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 | Code of Conduct | About PostgreSQL | Contact

PostgreSQL