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

Stephen Woodbridge woodbri at swoodbridge.com
Sat Apr 8 09:40:42 PDT 2017

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 


This email has been checked for viruses by Avast antivirus software.

More information about the gdal-dev mailing list