0

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?

  • The best option would be to update the database table directly rather than the DBF file. – Micha Jun 25 '16 at 8:03
  • I have no control. I cant update directly the database. Thanks – Za7pi Jun 27 '16 at 7:04
  • So even if there is some way to link a Postgresql table to an external dbf. you won't be able to implement it? – Micha Jun 28 '16 at 19:41
2

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/

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.