Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this community
I am trying to import data from Spatialite into PostGIS through drag and drop in DB Manager but all I received was an error:
Feature write errors:
Creation error for features from #1 to #202. Provider errors was:
PostGIS error while adding features: ERROR: invalid input syntax for integer: ""
Is there any way to fix this?
Thanks.
It was my stupidity: after inspections, I found my Spatialite Integer columns contain "" - fixed it by turning them all to null and import again.
