Making data outside my PostGIS database
appear to be in my database.
In 2003, a new specification "SQL Management of External Data" (SQL/MED) was added to the SQL standard.
It is a standardized way of handling access to remote objects from SQL databases.
FDWs make external data sources (text files, web services, etc.) look like tables in the database and so users have easy access to them using SQL commands.
Very much so! In the early days of oracle_fdw, it did not support geometry.
So we had to
and
Even then ...
Postgres_FDW
www.postgresql.org/docs/9.6/static/postgres-fdw.html
Oracle_FDW
OGR_FDW
github.com/pramsey/pgsql-ogr-fdw
OGR FDW: Shape file example
OGR FDW SQLServer database example:
OGR FDW WFS example:
Thank you!
slides.com/aileenheal/deck
@aileen_heal
aileenheal@astuntechnology.com
www.astuntechnology.com