table of contents
other versions
- buster 11.9-0+deb10u1
| DEALLOCATE(7) | PostgreSQL 11.9 Documentation | DEALLOCATE(7) |
NAME¶
DEALLOCATE - deallocate a prepared statementSYNOPSIS¶
DEALLOCATE [ PREPARE ] { name | ALL }
DESCRIPTION¶
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).
PARAMETERS¶
PREPAREThis key word is ignored.
name
The name of the prepared statement to deallocate.
ALL
Deallocate all prepared statements.
COMPATIBILITY¶
The SQL standard includes a DEALLOCATE statement, but it is only for use in embedded SQL.SEE ALSO¶
EXECUTE(7), PREPARE(7)| 2020 | PostgreSQL 11.9 |