Note: The following description applies both to Postgres-XC and PostgreSQL if not described explicitly.
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.
This key word is ignored.
The name of the prepared statement to deallocate.
Deallocate all prepared statements.