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.
Last updated