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?

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

1 Answer 1

Reset to default
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/

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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