DEALLOCATE

Synopsis

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

Syntax

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

deallocate

DEALLOCATE - 图1

Semantics

name

Specify the name of the prepared statement to deallocate.

ALL

Deallocate all prepared statements.

Examples

Prepare and deallocate an insert statement.

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

See also