<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body text="#000000" bgcolor="#ffffff">
I try to import various files from PostgreSQL to GRASS in GRASS70. <br>
<i><br>
db.connect driver=pg
database='host=<server>,dbname=<database>,schema=<schamename>'<br>
db.login user="sustaincity" pass="+++"<br>
db.connect -p <br>
db.tables -p |less <br>
<br>
for i in {1..3};<br>
do<br>
v.in.ogr dsn='PG:host=<servername>
dbname=<dbname> user=<username>' layer=schema.layer
output=layer$i type=boundary,centroid -o --o;<br>
done</i><br>
<br>
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.:<br>
<i>ERROR: Layer <schema.layername> not available</i><br>
<br>
any ideas?<br>
</body>
</html>