DEALLOCATE statement [YSQL]

Synopsis

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

{{%ebnf%}} deallocate {{%/ebnf%}}

Specify the name of the prepared statement to deallocate.

Deallocate all prepared statements.

Prepare and deallocate an insert statement.

plpgsql

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

plpgsql

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

plpgsql

yugabyte=# DEALLOCATE ins;