F.11. dblink

— opens a persistent connection to a remote database

dblink_connect_u

— opens a persistent connection to a remote database, insecurely

— closes a persistent connection to a remote database

dblink

— executes a query in a remote database

— executes a command in a remote database

dblink_open

— opens a cursor in a remote database

dblink_close

— closes a cursor in a remote database

— returns the names of all open named dblink connections

dblink_error_message

— gets last error message on the named connection

— sends an async query to a remote database

dblink_is_busy

— checks if connection is busy with an async query

— retrieve async notifications on a connection

— gets an async query result

dblink_cancel_query

— cancels any active query on the named connection

— 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

— 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

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