<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Dear all</p>
<p>A short not on the manual v.in.ogr. It appears to be out of date
for PostGIS import. I have to call the schema in "layer" to have
schema-support. My previous code as given below was been running
without this.</p>
<p>Best Regards,</p>
<p>patrick schirmer</p>
<p><br>
</p>
<p>#Syntax in the past and still recommended according to manual:<br>
</p>
<p>INPATH="PG:dbname=mydatabase schema=myschema" <br>
</p>
<p>db.connect driver=pg database=mydatabase schema=myschema
#eventially unnecessary<br>
</p>
<p>v.in.ogr input="$INPATH" layer="mytablename"
out=mygrasstablename type="point" -r <br>
</p>
<p><br>
</p>
<p>#Working code in version GRASS72:</p>
<p>INPATH="PG:dbname=$DB_NAME"</p>
<p>db.connect driver=pg database=mydatabase #no schema required, as
it has to be called inside v.in.ogr<br>
</p>
<p>v.in.ogr input="$INPATH" layer="myschema.mytablename"
out=mygrasstablename type="point" -r </p>
<p><br>
</p>
<p>#extract of manual:<br>
</p>
<div class="code">
<pre>db.connect driver=pg database=test schema=user1
db.login user=user1 password=pwd1
# -> input="PG:dbname=test user=user1 password=pwd1" layer="user1.river"
v.in.ogr input=PG: layer=river output=river
db.select table=user1.river
</pre>
</div>
</body>
</html>