PostgreSQL Reference Manual - Volume 2 - Programming Guide by The PostgreSQL Global Development Group Paperback (6"x9"), 408 pages ISBN 0954612035 RRP £19.95 ($34.95) Sales of this book support the PostgreSQL project! Get a printed copy>>>

PostgreSQL Reference Manual Volume 2 Buy the book here! >>> only $34.95

3.3 Closing a Connection

To close a connection, use the following statement:

EXEC SQL DISCONNECT connection;

The connection can be specified in the following ways:

• connection-name
• DEFAULT
• CURRENT
• ALL

If no connection name is specified, the current connection is closed.

It is good style that an application always explicitly disconnect from every connection it opened.