Foreign Data Wrappers

FDWs allow heterogeneous data environments to be queried through one PostgreSQL connection without ETL pipelines or duplicated data. Foreign Data Wrappers let PostgreSQL query external sources such as MySQL, MongoDB, and flat files as local tables. FDWs allow PostgreSQL to serve as a unified query layer over multiple underlying systems.