[GRASS-user] postgreSQL import

Patrick S. patrick_GIS at gmx.ch
Wed Mar 14 05:50:57 EDT 2012


I try to import various files from PostgreSQL to GRASS in GRASS70.
/
db.connect driver=pg 
database='host=<server>,dbname=<database>,schema=<schamename>'
db.login user="sustaincity" pass="+++"
db.connect -p
db.tables -p |less

for i in {1..3};
     do
         v.in.ogr dsn='PG:host=<servername> dbname=<dbname> 
user=<username>' layer=schema.layer output=layer$i 
type=boundary,centroid  -o --o;
     done/

This does only work for few layers. Some layers have many items inside 
and these are not recognized, although I can view them through db.tables 
-p.:
/ERROR: Layer <schema.layername> not available/

any ideas?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20120314/d634ed5f/attachment.html


More information about the grass-user mailing list