Skip site navigation (1)Skip section navigation (2)

  
 
  

home | help 
DEALLOCATE(7)		  PostgreSQL 18.6 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 18.6 		      2026			   DEALLOCATE(7)

Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=DEALLOCATE&sektion=7&manpath=FreeBSD+Ports+15.1.quarterly>

home | help