F.11. dblink

— opens a persistent connection to a remote database

— opens a persistent connection to a remote database, insecurely

— closes a persistent connection to a remote database

— executes a query in a remote database

— executes a command in a remote database

— opens a cursor in a remote database

— returns rows from an open cursor in a remote database

— closes a cursor in a remote database

— returns the names of all open named dblink connections

— gets last error message on the named connection

— sends an async query to a remote database

— checks if connection is busy with an async query

— retrieve async notifications on a connection

— gets an async query result

— cancels any active query on the named connection

— returns the positions and field names of a relation’s primary key fields

— 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

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