[GRASSLIST:3720] Re: v.in.ogr and v.out.ogr

[Radim Blazek]

On Saturday 19 June 2004 01:36, cirgeo_admin wrote:
> Hi all grass users,
>
> Firstly thanks to Radim for clearing up for me the fact that I (obviously)
> have to compile gdal-ogr with pg support if I want to use it for postgis
> import/export.
>
> I am using a lot the new module v.out.ogr and v.in.ogr to import export
> postgis:  I came up with the following observations:
>
> the following command gave me an error:
> v.out.ogr input=MA_finale dsn="PG:host=localhost dbname=EvA" layer=mamma
> field=1 format=PostgreSQL
>
> ERROR 1: AddGeometryColumn failed for layer mamma, layer creation has
> failed. ERROR: Cannot create layer

Is it valid PostGIS database? Can you create table with geometry in psql?:
create table test (geom geometry);

> If I IMPORT from a valid postgis database everything goes fine but the
> attributes are not editable... is that normal??

In d.what.vect? Did you notice -e flag?

Radim