PostgreSQL 17 64-bit for Windows FDWs

We are pleased to provide binaries for file_textarray_fdw and odbc_fdw for PostgreSQL 17 Windows 64-bit.

To use these, copy the files into your PostgreSQL 17 Windows 64-bit install folders in same named folders and then run CREATE EXTENSION as usual in the databases of your choice. More details in the packaged README.txt

These were compiled against PostgreSQL 17.2 using msys2 / mingw64 and tested against PostgreSQL 17.2 EDB windows distribution.

This package contains the following FDWs:

Note this package does not include ogr_fdw since ogr_fdw is packaged as part of PostGIS Bundle packages from EnterpriseDb Stackbuilder (for PostGIS >= 3.0) .

If you do not have PostGIS Bundle installed (and don't want to for some reason) and want to use ogr_fdw on windows, you can download from: Winnie's PG 17 Extras. ogr_fdw is a great FDW for querying not just spatial data, but also a ton of other file formats or relational (including odbc, dbase files, spreadsheets) since spatial is a superset of most file formats and databases. Even sweeter, the ogr_fdw extension fully supports the IMPORT FOREIGN SCHEMA feature, thus allowing you to do things like link in a whole folder of CSV files, or a workbook with many sheets with following steps:

CREATE EXTENSION IF NOT EXISTS ogr_fdw;
CREATE SERVER fds_csvs
    FOREIGN DATA WRAPPER ogr_fdw
    OPTIONS( datasource  'C:/fdw_data/csvs' , format 'CSV');

CREATE SCHEMA IF NOT EXISTS staging;

IMPORT FOREIGN SCHEMA ogr_all FROM SERVER fds_csvs INTO staging;