[gdal-dev] I can't get ogr2ogr to overwrite an existing table

[Stephen Woodbridge]

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?

ogr2ogr -t_srs EPSG:4326 -nln roads -nlt PROMOTE_TO_MULTI -f PostgreSQL 
-overwrite -lco OVERWRITE=YES -lco PRECISION=NO -lco GEOMETRY_NAME=geom 
-lco FID=gid "PG:dbname=buildings host=localhost port=5435 user=postgres 
active_schema=census" /data/census/tmp-10195/tl_2016_06013_roads.shp

ERROR 1: CREATE TABLE "census"."roads" ( "gid" SERIAL, PRIMARY KEY ("gid") )
ERROR:  relation "roads" already exists

ERROR 1: Terminating translation prematurely after failed
translation of layer tl_2016_06013_roads (use -skipfailures to skip errors)


ogr2ogr -t_srs EPSG:4326 -nln census.roads -nlt PROMOTE_TO_MULTI -f 
PostgreSQL -overwrite -lco OVERWRITE=YES -lco PRECISION=NO -lco 
GEOMETRY_NAME=geom -lco FID=gid "PG:dbname=buildings host=localhost 
port=5435 user=postgres" /data/census/tmp-10747/tl_2016_06013_roads.shp

ERROR 1: CREATE TABLE "census"."roads" ( "gid" SERIAL, PRIMARY KEY ("gid") )
ERROR:  relation "roads" already exists

ERROR 1: Terminating translation prematurely after failed
translation of layer tl_2016_06013_roads (use -skipfailures to skip errors)

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