We are pleased to provide binaries for file_textarray_fdw and odbc_fdw for PostgreSQL 13 Windows 64-bit.
To use these, copy the files into your PostgreSQL 13 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
This package contains the following FDWs:
-
odbc_fdw (version 0.5.2.3) (source) 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 source, 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 packages from EnterpriseDb Stackbuilder (for PostGIS >= 3.0) .
If you do not have PostGIS installed (and don't want to for some reason) and want to use ogr_fdw on windows, you can download from:
Winnie's PG 13 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.