deallocate(7) centos man page | unix.com

DEALLOCATE(7)						  PostgreSQL 9.2.7 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.2.7						    2014-02-17							     DEALLOCATE(7)