↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3
Historical version. PostgreSQL 9.0 reached end of support in October 2015. See the current manual for supported releases.
PostgreSQL 9.0.23 Documentation
Prev Up Chapter 33. ECPG - Embedded SQL in C Next

33.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.

Prev Home Next
Connecting to the Database Server Up Running SQL Commands

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.