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?

3
  • The best option would be to update the database table directly rather than the DBF file.
    – Micha
    Jun 25, 2016 at 8:03
  • I have no control. I cant update directly the database. Thanks
    – Za7pi
    Jun 27, 2016 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, 2016 at 19:41

1 Answer 1

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.