EnterpriseDB
  • Home
  • Category
    Installation & Getting Started Quick Start Reference User Guides
  • Product
    EDB Backup and Recovery Tool EDB JDBC Connector EDB .NET Connector EDB OCL Connector EDB ODBC Connector EDB*Plus EDB Postgres Advanced Server EDB Postgres Ark Platform EDB Postgres Cloud Database Service EDB Postgres Enterprise Manager EDB Postgres Failover Manager EDB Postgres Hadoop Foreign Data Wrapper EDB Postgres Language Pack EDB Postgres Migration Portal EDB Postgres Migration Toolkit EDB Postgres MongoDB Foreign Data Wrapper EDB Postgres MySQL Foreign Data Wrapper EDB Postgres PgBouncer EDB Postgres Pgpool-II EDB Postgres PostGIS EDB Postgres Replication Server EDB Postgres Slony Replication PostgreSQL pgAdmin 4

PostgreSQL → 13.1 → Reference → Manual
Other versions of this page: 13.1 · 13.0 · 12.5 · 12.4 · 12.3 · 12.2 · 12.1 · 12.0 · 11.10 · 11.9 · 11.8 · 11.7 · 11.6 · 11.5 · 11.4 · 11.3 · 11.2 · 11.1 · 11.0 · 10.15 · 10.14 · 10.13 · 10.12 · 10.11 · 10.10 · 10.9 · 10.8 · 10.7 · 9.6.20 · 9.6.19 · 9.6.18 · 9.6.17 · 9.6.16 · 9.6.15 · 9.6.14 · 9.6.13 · 9.6.12 · 9.5.24 · 9.5.23 · 9.5.22 · 9.5.21 · 9.5.20 · 9.5.19 · 9.5.18 · 9.5.17 · 9.5.16 · 9.4.26 · 9.4.25 · 9.4.24 · 9.4.23 · 9.4.22 · 9.4.21

Get Postgres Tips and Tricks

Subscribe to get advanced Postgres how-tos.

F.10. dblink
Prev UpAppendix F. Additional Supplied ModulesHome Next

F.10. 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

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

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


Prev Up Next
F.9. cube Home dblink_connect
© 2021 EnterpriseDB Corporation. All rights reserved. | Privacy Policy | Terms of Use | Trademarks