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:
-
odbc_fdw (version 0.5.2.3), patched to work with PostgreSQL 17 for connecting to ODBC data sources such as SQL Server, Oracle, MS Access databases, and anything else that has a 64-bit ODBC driver. Note that since this is for PostgreSQL 64-bit, it can only use ODBC 64-bit connections.
- file_textarray_fdw, great and fast for working with arbitrary and pesky delimited data. Especially where they weren't considerate enough to give you the same number of columns per row.
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;