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 have created a postgis table from point.shp with 5 fields containing 20 records. Now I want to populate the table with another 150 records keeping the previous 20 records so that the total records count reach 170.
I have tried 'QGIS to Postgis shp loader (SPIT - Shape to PG Import Tool)' and also 'Postgis shapefile & DBF loader' but in both cases the tools are asking to overwrite the previous records in the table.
There is more than one way to do it:
Import the new shapefile to PostGIS as separate table, then do
INSERT INTO tablemain SELECT * FROM tablenew;
Open the PostGIS table and the shapefile in QGIS, edit the POSTGIS table, copy and paste the new features.
