manpagez: man pages & more
man DEALLOCATE(7)
Home | html | info | man
DEALLOCATE(7)           PostgreSQL 9.4.15 Documentation          DEALLOCATE(7)




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


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), PREPARE(7)



PostgreSQL 9.4.15                    2017                        DEALLOCATE(7)

PostgreSQL 9.4.15 - Generated Mon Nov 27 18:27:28 CST 2017
© manpagez.com 2000-2025
Individual documents may contain additional copyright information.