select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Foreign data wrappers

dblink

connect to other PostgreSQL databases from within a database

pgext.cloud · Website · Documentation · License text · Control file

Overview

Packagedblink
Version1.2
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPostgreSQL contrib
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
Latest commit2026-05-14
Latest release2026-05-14
Catalogue updated2026-07-29

Related extensions

Required by

auto_jobA PostgreSQL extension for background job scheduling
cigrationOnline migration and rebalancing of colocated Citus shards for cluster expansion, contraction, and worker replacement.
data2pgMigration framework for discovering, copying, and comparing non-PostgreSQL database content through foreign data wrappers.
edb_cloneschemaLocal and cross-database schema cloning for EPAS.
efm_extensionSQL interface for EDB Failover Manager cluster management
emajEnables fine-grained write logging and time travel on subsets of the database.
mimeoExtension for specialized, per-table replication between PostgreSQL instances
omni_schemaAdvanced schema management tooling
omni_testTesting framework
omni_vfsVirtual File System
pg_cron_helperExtension to help functionality of pg_cron
pg_dbwaAnalyzes local or remote PostgreSQL workloads using historical pg_stat_statements snapshots.
pg_jobmonExtension for logging and monitoring functions in PostgreSQL
pg_paxosPaxos distributed consensus functions and table replication for PostgreSQL
pg_profilePostgreSQL load profile repository and report builder
pgbouncer_fdwExtension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
pgbouncer_wrapperMonitor and control the PgBouncer administration console through SQL views and functions backed by dblink_fdw
pgelogExtended logging via pseudo-autonomous transactions
pgintegrityTrigger-based row integrity watermark checker for PostgreSQL tables
simple_timeseriestime-series extension
softvisio_adminProprietary SQL administration extension for database/role provisioning and cluster-wide extension inventory and updates via dblink.
synchronize_logical_slotsSynchronizes logical replication slots from an EDB Advanced Server 12 primary to synchronous standby servers.
sys_syn_dblinkPL/pgSQL synchronization processor that pulls sys_syn queues over named dblink connections, transforms batches, writes local tables, and returns processing status to the source database.

See also

postgres_fdwforeign-data wrapper for remote PostgreSQL servers
db_migratorTools to migrate other databases to PostgreSQL
pgspider_extforeign-data wrapper for remote PGSpider servers
pglogicalPostgreSQL Logical Replication
citusDistributed PostgreSQL as an extension
pgcloneClone PostgreSQL databases, schemas, tables, and functions across environments
plproxyDatabase partitioning implemented as procedural language
mimeoExtension for specialized, per-table replication between PostgreSQL instances
mysql_fdwForeign data wrapper for querying a MySQL server
db2_fdwforeign data wrapper for DB2 access