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

Marcello Benigno benigno.marcello at gmail.com
Tue Apr 19 13:17:35 EDT 2011


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20110419/9829800b/attachment.html


More information about the grass-user mailing list