On 4/8/2017 12:29 PM, Even Rouault wrote:
On vendredi 7 avril 2017 15:59:49 CEST Stephen Woodbridge wrote:

 > Hi all,

 >

 > I'm having trouble figuring out how to overwrite an existing table with

 > ogr2ogr. I have tried various combos of arguments without success.

 >

 > What am I doing wrong?

I'm not sure. Similar requests work for me with GDAL 2.1. Maybe try to manually drop the table (if it is a table...)

Seeing the 'CREATE TABLE "census"."roads" ( "gid" SERIAL, PRIMARY KEY ("gid") )' statement, it makes me wonder if you are not using an older GDAL version (Newer versions will issue a CREATE TABLE with all columns) that might have trouble with overwriting existing tables and schemas.

Note for everyone: please mention the version you are using.

Sorry, I know that:

$ ogrinfo --version
GDAL 1.10.1, released 2013/08/26

on Ubuntu 14.04.5 LTS

ok, it is not as convenient but I can drop the table rather than rely on -overwrite.

Thanks,
  -Steve

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to