Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from http://www.postgresql.org/docs/devel/static/sql-deallocate.html below:

PostgreSQL: Documentation: devel: DEALLOCATE

This documentation is for an unsupported version of PostgreSQL.

You may want to view the same page for the

version, or one of the other supported versions listed above instead.

DEALLOCATE — deallocate a prepared statement

DEALLOCATE [ PREPARE ] { name | ALL }

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.

PREPARE

This key word is ignored.

name

The name of the prepared statement to deallocate.

ALL

Deallocate all prepared statements.

The SQL standard includes a DEALLOCATE statement, but it is only for use in embedded SQL.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4