[GRASS-user] Accessing PostGIS from GRASS 6.2.1

[Stephan Holl]

Hello Christian,

christian.braun at tudor.lu, [20070620 - 12:24:51]

> I have a problem downloading the right geometries from PostGIS tables.
> 
> I have a PostGIS table storing two geometry columns. How can I access 
> these two different columns with v.in.ogr.
> v.in.ogr -l dsn=... gives me two times the same name of the table.
> A workaround with views or temporary tables won't work because GRASS 
> accesses the geometry_columns table and there are no entries for
> temporary tables or views.

Just add 2 entries in geometry_columns, one for the first geom-column,
one for the second. this should work.

btw OGC sais said every layers needs an entry in the geometry_columns
because that is the place where the PostGIS-clients look for layers.
Adding views there makes them work as well.

Best
	Stephan
-- 
Stephan Holl <stephan.holl at intevation.de>, http://intevation.de/~stephan
Tel: +49 (0)541-33 50 8 32 | Intevation GmbH | AG Osnabrück - HR B 18998
Geschäftsführer:  Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner