Documentation → PostgreSQL 9.0

Supported Versions: Current (11) / 10 / 9.6 / 9.5 / 9.4 / 9.3

Development Versions: devel

Unsupported versions: 9.2 / 9.1 / 9.0 / 8.4 / 8.3

PostgreSQL 9.0.23 Documentation
Prev	Up	Appendix F. Additional Supplied Modules	Next

F.8. dblink

Table of Contents
dblink_connect -- opens a persistent connection to a remote database
dblink_connect_u -- opens a persistent connection to a remote database, insecurely
dblink_disconnect -- closes a persistent connection to a remote database
dblink -- executes a query in a remote database
dblink_exec -- executes a command in a remote database
dblink_open -- opens a cursor in a remote database
dblink_fetch -- returns rows from an open cursor in a remote database
dblink_close -- closes a cursor in a remote database
dblink_get_connections -- returns the names of all open named dblink connections
dblink_error_message -- gets last error message on the named connection
dblink_send_query -- sends an async query to a remote database
dblink_is_busy -- checks if connection is busy with an async query
dblink_get_notify -- retrieve async notifications on a connection
dblink_get_result -- gets an async query result
dblink_cancel_query -- cancels any active query on the named connection
dblink_get_pkey -- returns the positions and field names of a relation's primary key fields
dblink_build_sql_insert -- builds an INSERT statement using a local tuple, replacing the primary key field values with alternative supplied values
dblink_build_sql_delete -- builds a DELETE statement using supplied values for primary key field values
dblink_build_sql_update -- builds an UPDATE statement using a local tuple, replacing the primary key field values with alternative supplied values

dblink is a module which supports connections to other PostgreSQL databases from within a database session.

Prev	Home	Next
cube	Up	dblink_connect