[GRASS-user] Problem to overwrite postgis layer with v.out.ogr

GRASS GRASS user
,
1

Hi All,

I’m trying export a layer overwriting the table in PostGIS fortmat:

v.out.ogr -c input=“bacia_usuario” type=area ‘dsn=PG:host=localhost dbname=gis user=marcello password=mypass’ olayer=bacia_1 layer=1 format=PostgreSQL

but the prompt show the message:

ERROR 1: Layer bacia_1 already exists, CreateLayer failed.
Use the layer creation option OVERWRITE=YES to replace it.
ERROR: Unable to create OGR layer

So I tried using this commands, with no results:

v.out.ogr -c input=“bacia_usuario” type=area ‘dsn=PG:host=localhost dbname=gis user=marcello password=mypass’ olayer=bacia_1 layer=1 format=PostgreSQL –overwrite

v.out.ogr -c OVERWRITE=YES input=“bacia_usuario” type=area ‘dsn=PG:host=localhost dbname=gis user=marcello password=mypass’ olayer=bacia_1 layer=1 format=PostgreSQL

What is the correct way to do this?

Thanks in advance,

Marcello Benigno B. de Barros Filho
Prof. do Curso Superior de Tecnologia em Geoprocessamento - IFPB
Mestre em Ciências Geodésicas e Tecnologias da Geoinformação - UFPE
http://profmarcello.blogspot.com
http://about.me/marcello.benigno

2

Hi All,

I’m trying export a layer overwriting the table in PostGIS fortmat:

v.out.ogr -c input=“bacia_usuario” type=area ‘dsn=PG:host=localhost dbname=gis user=marcello password=mypass’ olayer=bacia_1 layer=1 format=PostgreSQL

but the prompt show the message:

ERROR 1: Layer bacia_1 already exists, CreateLayer failed.
Use the layer creation option OVERWRITE=YES to replace it.
ERROR: Unable to create OGR layer

So I tried using this commands, with no results:

v.out.ogr -c input=“bacia_usuario” type=area ‘dsn=PG:host=localhost dbname=gis user=marcello password=mypass’ olayer=bacia_1 layer=1 format=PostgreSQL –overwrite

v.out.ogr -c OVERWRITE=YES input=“bacia_usuario” type=area ‘dsn=PG:host=localhost dbname=gis user=marcello password=mypass’ olayer=bacia_1 layer=1 format=PostgreSQL

What is the correct way to do this?

v.out.ogr … lco=“OVERWRITE=YES”
might do it

··· 
-- 
Micha Silver
Arava Development Co. +972-52-3665918
[http://www.surfaces.co.il](http://www.surfaces.co.il)
3

Hi,

2011/4/19 Marcello Benigno <benigno.marcello@gmail.com>:

v.out.ogr -c input="bacia_usuario" type=area 'dsn=PG:host=localhost
dbname=gis user=marcello password=mypass' olayer=bacia_1 layer=1
format=PostgreSQL --overwrite

this syntax will work only in GRASS 6.4.2+ otherwise use `lco="OVERWRITE=YES"`

Martin

--
Martin Landa <landa.martin gmail.com> * http://geo.fsv.cvut.cz/~landa