[GIS] PostGIS Shapefile and DBF Loader – automatically Linked dbf file

dbfpgadmin-3postgispostgresql

This is my system:

Windows 7

Postgresql 9.5

PGADMIN 3

PostGIS Shapefile and DBF Loader plugin

I have imported data from a DBF file correctly with the plugin.

My problem: This DBF file changes every day. Is there any option to have the file linked with my Postgresql database?

Best Answer

You might consiider PostGIS FDW (Foreign Data Wrapper) - it will connect to remote files such as Shapefiles or CSV, and they will appear and be queryable just like 'normal' PostGres tables.

I think you'd need to use the GDAL/OGR FDW library - it supports shapefile connections.

But don't take my word for it: http://postgis.net/2014/12/19/postgis_fdw/

Related Question