This page in other versions: 9.0 / 9.1 / 9.2 / 9.3 / 9.4  |  Development versions: devel  |  Unsupported versions: 8.3 / 8.4

dblink_disconnect

Name

dblink_disconnect -- closes a persistent connection to a remote database

Synopsis

    dblink_disconnect() returns text
    dblink_disconnect(text connname) returns text
   

Description

dblink_disconnect() closes a connection previously opened by dblink_connect(). The form with no arguments closes an unnamed connection.

Arguments

conname

The name of a named connection to be closed.

Return Value

Returns status, which is always OK (since any error causes the function to throw an error instead of returning).

Example

 test=# select dblink_disconnect();
  dblink_disconnect
 -------------------
  OK
 (1 row)

 select dblink_disconnect('myconn');
  dblink_disconnect
 -------------------
  OK
 (1 row)
   
Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group