Free Webmaster Tools and Resources

W3-Tools.com

Articles

Search Engine Optimization Domain Names Webmasters Web design

Webmaster Forum Webmaster News Links Directory

SEO Tools

Search Engine Spider Simulator Keyword Analyser Tool Keywords Generator

Domain Tools

Domain Name Checker Whois Domain Lookup Domain Typo Generator

Web Utilities

HTTP Header Viewer Link Extractor Mime Types List

HTML Tools

Websafe Color Tool HTML Entity Chart

Documentation

PHP Manual PEAR Manual Smarty Manual PHP-GTK Manual Apache Manual MySQL Manual PostgreSQL Manual

PostgreSQL Manual

This manual is provided as a courtesy. It is not an official source. Please check postgresql.org for updated information.

PostgreSQL Manual

PostgreSQL 8.1.3 Documentation
Prev	Fast Backward		Fast Forward	Next

DEALLOCATE

Name

DEALLOCATE -- deallocate a prepared statement

Synopsis

DEALLOCATE [ PREPARE ] plan_name

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.

Parameters

PREPARE: This key word is ignored.
plan_name: The name of the prepared statement to deallocate.

Compatibility

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

Newsletter

Join to our newsletter and receive news and updates about our site.
Your name:
E-mail address:
Action:

Hosted by

Search

			Links