Foreign Data Wrappers (FDW)#
In 2003, SQL was expanded to include SQL/MED (SQL Management of External Data). PostgreSQL 9.1 supports this read-only, 9.3 then also write. Since then, a number of Foreign Data Wrappers (FDW) have been developed for PostgreSQL.
The following is just a small selection of the best-known FDWs:
Note
Most of these wrappers are not officially supported by the PostgreSQL Global Development Group (PGDG).
Generic SQL wrappers#
Specific SQL wrappers#
NoSQL database wrappers#
File wrappers#
Geo wrappers#
- GDAL/OGR
FDW for the GDAL/OGR driver including databases like Oracle and SQLite as well as file formats like MapInfo, CSV, Excel, OpenOffice, OpenStreetMap PBF and XML.
- Geocode/GeoJSON
A collection of FDWs for PostGIS
- Open Street Map PBF
FDW for Open Street Map PBF
Generic web wrappers#
- ICAL
FDW for ICAL
- IMAP
FDW for the Internet Message Access Protocol (IMAP)
- RSS
FDQ for RSS feeds
See also