DEALLOCATE

Synopsis

Use the DEALLOCATE statement to deallocate a previously prepared SQL statement.

Syntax

deallocate ::= DEALLOCATE [ PREPARE ] { name | ALL }

deallocate

DEALLOCATEPREPAREnameALL

Semantics

name

Specify the name of the prepared statement to deallocate.

ALL

Deallocate all prepared statements.

Examples

Prepare and deallocate an insert statement.

yugabyte=# CREATE TABLE sample(k1 int, k2 int, v1 int, v2 text, PRIMARY KEY (k1, k2));

yugabyte=# PREPARE ins (bigint, double precision, int, text) AS
               INSERT INTO sample(k1, k2, v1, v2) VALUES ($1, $2, $3, $4);

yugabyte=# DEALLOCATE ins;

See also