# phpman > man > DEALLOCATE(7)

[DEALLOCATE(7)](https://www.chedong.com/phpMan.php/man/DEALLOCATE/7/markdown)                      PostgreSQL 14.23 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 14.23                                2026                                   [DEALLOCATE(7)](https://www.chedong.com/phpMan.php/man/DEALLOCATE/7/markdown)