DEALLOCATE
New in v0.9.7.
DEALLOCATE clears prepared statements that have been created during the current session. Even without an explicit DEALLOCATE command, all prepared statements will be cleared at the end of a session.
Syntax
| Field | Use |
|---|---|
| PREPARE | Disregarded. |
| name | The name of the prepared statement to clear. |
| ALL | Clear all prepared statements from this session. |
Example
DEALLOCATE a;