# DEALLOCATE - man(7) - [phpMan]

[_DEALLOCATE_(7)](https://www.chedong.com/phpMan.php/man/DEALLOCATE/7/markdown)                      PostgreSQL 16.14 Documentation                      [_DEALLOCATE_(7)](https://www.chedong.com/phpMan.php/man/DEALLOCATE/7/markdown)

## NAME
       DEALLOCATE - deallocate a prepared statement

## SYNOPSIS
       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)](https://www.chedong.com/phpMan.php/man/PREPARE/7/markdown).

## PARAMETERS
       PREPARE
           This 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)](https://www.chedong.com/phpMan.php/man/EXECUTE/7/markdown), [**PREPARE**(7)](https://www.chedong.com/phpMan.php/man/PREPARE/7/markdown)

PostgreSQL 16.14                                2026                                   [_DEALLOCATE_(7)](https://www.chedong.com/phpMan.php/man/DEALLOCATE/7/markdown)