F.11. dblink

​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

dblinkis a module that supports connections to otherPostgreSQLdatabases from within a database session.

See alsopostgres_fdw, which provides roughly the same functionality using a more modern and standards-compliant infrastructure.