DEALLOCATE

Deallocate a prepared statement

Table of contents

Synopsis

DEALLOCATE [PREPARE] { name | ALL }

Description

DEALLOCATE is used to deallocate a previously prepared SQL statement and free the reserved resources. It is not meant to be explicitly issued by a user but it’s used by some clients (e.g. libpq) over Postgres Wire Protocol as an alternative way of deallocating a prepared statement to the protocol’s Close (F) message.

Parameters

name

The name of the prepared statement to deallocate.

ALL

Deallocate all prepared statements