Steampipe bundles Postgres with an FDW extension that supports a growing ecosystem of plugins. Works great with both spatial and non-spatial data.Ī generic FDW to access VirtDB data sources (SAP ERP, Oracle RDBMS)ĬLI and FDW extension: AGPL, Plugins: Apache 2.0 Exposes vector data as PostGIS geometry columns if you have PostGIS installed.
Uses the GDAL library which supports hundreds of formats to access the data.
#Aws postgresql rds fdw windows
,, and part of PostGIS windows bundle (application stackbuilder)Ĭan access many kinds of data sources (Relational databases, spreadsheets, CSV files, web feature services, etc). More recent than the above, advertises write support.Ĭan be used to access data stored in any database supported by the sqlalchemy python toolkit. Generic SQL Database Wrappers Data SourceĬartoDB took over active development of the ODBC FDW for PG 9.5+ Please keep in mind that most of these wrappers are not officially supported by the PostgreSQL Global Development Group (PGDG) and that some of these projects are still in Beta version. Another fdw list can be found at the PGXN website. This page list some of the wrappers currently available. There are now a variety of Foreign Data Wrappers (FDW) available which enable PostgreSQL Server to different remote data stores, ranging from other SQL databases through to flat file. In 2011, PostgreSQL 9.1 was released with read-only support of this standard, and in 2013 write support was added with PostgreSQL 9.3. It is a standardized way of handling access to remote objects from SQL databases. In 2003, a new specification called SQL/MED ("SQL Management of External Data") was added to the SQL standard.
0 kommentar(er)
