- publishing free software manuals
The PostgreSQL 9.0 Reference Manual - Volume 2 - Programming Guide
by The PostgreSQL Global Development Group
Paperback (6"x9"), 478 pages
ISBN 9781906966065
RRP £14.95 ($19.95)

Sales of this book support the PostgreSQL project! Get a printed copy>>>

3.10.2 Additional/missing embedded SQL statements

CLOSE DATABASE
This statement closes the current connection. In fact, this is a synonym for ECPG's DISCONNECT CURRENT.:
$CLOSE DATABASE;         /* close the current connection */
EXEC SQL CLOSE DATABASE;
FREE cursor_name
Due to the differences how ECPG works compared to Informix's ESQL/C (i.e. which steps are purely grammar transformations and which steps rely on the underlying run-time library) there is no FREE cursor_name statement in ECPG. This is because in ECPG, DECLARE CURSOR doesn't translate to a function call into the run-time library that uses to the cursor name. This means that there's no run-time bookkeeping of SQL cursors in the ECPG run-time library, only in the PostgreSQL server.
FREE statement_name
FREE statement_name is a synonym for DEALLOCATE PREPARE statement_name.
ISBN 9781906966065The PostgreSQL 9.0 Reference Manual - Volume 2 - Programming GuideSee the print edition