SQL Commands / Cursors & Prepared Statements

DEALLOCATE

deallocate a prepared statement

Reading PG 18current·documented in 25 of 30 versions, 7.3 to 20

6.4 6.5 7.0 7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Syntax

DEALLOCATE [ PREPARE ] { name | ALL }

Syntax diagrams

Read left to right. Branches are choices, bypasses are optional, loops repeat. Select an underlined parameter to open its rule.

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.

Related entries

EXECUTE PREPARE

Definition snapshot: b7bd9cda · English manual source