select open change scope Open full search

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

Extensions / Foreign data wrappers

postgres_fdw

foreign-data wrapper for remote PostgreSQL servers

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

Overview

Packagepostgres_fdw
Version1.1
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

edb_cloneschemaLocal and cross-database schema cloning for EPAS.
mypg_shardingmypg sharding utilities for PostgreSQL
omni_schemaAdvanced schema management tooling
pathman_shardingImproved sharding for pg_pathman.
pg_cron_helperExtension to help functionality of pg_cron
pg_repeaterReplicates utility statements and serialized query plans to a remote PostgreSQL node over postgres_fdw.
pg_shardmanManages PostgreSQL 10 hash-sharded tables across nodes using pg_pathman, postgres_fdw, and logical replication.
rep_fdwReplicate table changes to another PostgreSQL server through postgres_fdw
repeaterDemonstration extension for executing serialized raw query plans on a remote PostgreSQL node.

See also

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