Skip to main content
corrected spelling
Source Link
nmtoken
  • 13.6k
  • 5
  • 38
  • 89

Is it possible to load a shape fileshapefile to a postGISPostGIS database by replacing the content of the table with the new content of the shape fileshapefile WITHOUT DROPINGDROPPING the table? 

I want to do this using ogr2ogr. In

In the past I have used shp2pgsql, which gives you the option of four flags ((-drop|-append|-create|-prepare) but none of these options actually maintains the table and deletes the data. Is

Is there something like this in ogr2ogr?

Is it possible to load a shape file to a postGIS database by replacing the content of the table with the new content of the shape file WITHOUT DROPING the table? I want to do this using ogr2ogr. In the past I have used shp2pgsql, which gives you the option of four flags ((-drop|-append|-create|-prepare) but none of these options actually maintains the table and deletes the data. Is there something like this in ogr2ogr?

Is it possible to load a shapefile to a PostGIS database by replacing the content of the table with the new content of the shapefile WITHOUT DROPPING the table? 

I want to do this using ogr2ogr.

In the past I have used shp2pgsql, which gives you the option of four flags (-drop|-append|-create|-prepare) but none of these options actually maintains the table and deletes the data.

Is there something like this in ogr2ogr?

Source Link
user1919
  • 2.7k
  • 2
  • 32
  • 75

Use ogr2ogr to delete content of table and load new data from shapefile

Is it possible to load a shape file to a postGIS database by replacing the content of the table with the new content of the shape file WITHOUT DROPING the table? I want to do this using ogr2ogr. In the past I have used shp2pgsql, which gives you the option of four flags ((-drop|-append|-create|-prepare) but none of these options actually maintains the table and deletes the data. Is there something like this in ogr2ogr?