I just imported some shapefiles with the PostGIS importer. Because several errors and issues I had to split my shapefile in multiple parts. Then I imported them one by one. I thought I can easily merge them later on.
But now there is a problem. The import tool created a primary key called GID. And these identical PKs prohibit the merge. Doeas anybody know how to delete these GIDS, merge all the tables and create new PKs?
I'm thankful for any answer.