DEALLOCATE - deallocate a prepared statement

The SQL standard includes a DEALLOCATE statement, but it is only for use in embedded SQL.

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(7).

DEALLOCATE - deallocate a prepared statement

PREPARE This key word is ignored. name The name of the prepared statement to deallocate. ALL Deallocate all prepared statements.

EXECUTE(7), PREPARE(7) PostgreSQL 17.5 2025 DEALLOCATE(7)

DEALLOCATE [ PREPARE ] { name | ALL }