[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