I have a PostGIS Table I produced from importing a layer file itself created from a CSV. I am getting updates to the main file through other CSV files and need a method of importing the new CSV's into the PostGIS Table...

I've tried a few get arounds, Copy and paste seemed to be the best option but I'm unable to get the attribute data to save to the main table....

What would be the best way of getting the new data into the existing table?

| improve this question | | | | |
  • Hi, I use navicat for postgresql consol to solve this type of processes. There is an import tool for csv. You can append your new data to your existing table. You can save the import steps and schedule it for periodic upload. Navicat is not free.. but you can try a 30 days trial – Tamas Kosa Jun 17 '15 at 15:09
  • Updates, deletes or inserts or a combination thereof? – John Powell Jun 17 '15 at 15:44
  • This is quite a common problem, but it would be useful if you could give some more information on how existing data and update data are related. – John Powell Jun 18 '15 at 9:51
  • My data is being collected in the field through mobile devices it has attribute data and x,y,z. completed forms are uploaded to aggregation site, then downloaded at HO as CSV's. The data is continually being collected in the field and therefore being added to. The original data I imported into a PostGIS db from the layer file developed from the CSV. In trying to append the table with the cmd# COPY "Tablename" FROM "X:/filepath/name.csv" Delimeteres ',' NULL as ''; I keep getting an error so I can't append to the exsisting table the next batch of instances, as the geometry is missing – Tezzer Jul 1 '15 at 20:17

Your Answer

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

Browse other questions tagged or ask your own question.