Timeline for How to insert geometries from shapefile into existing table?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 2, 2012 at 15:54 | vote | accept | Oesor | ||
| Mar 7, 2012 at 13:04 | comment | added | David Bitner | shp2pgsql will not do updates. It will either create a new table, drop and recreate a table, or append to an existing table. You can use an insert trigger in PostgreSQL to turn the inserts into updates based on a primary key lookup, but that should be a separate question here. | |
| Mar 7, 2012 at 7:40 | comment | added | underdark | I think @Oesor is looking for an update operation rather than an append operation. Or does shp2pgsql do updates? | |
| Mar 6, 2012 at 23:50 | history | answered | David Bitner | CC BY-SA 3.0 |