Thanks for the link, Moritz
Remember to have read about ongoing changes, but couldn't find the
correct schema-import in the manual of 7.2.0. Syntax is already
layer="schema.table" in grass72.0 and apparently has been different in
the past.
cheers,
Patrick
On 09.08.2017 16:32, Moritz Lennert wrote:
On 09/08/17 16:13, patrick s. wrote:
Dear all
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.
This has been fixed a few months ago both in trunk and in the 7.2
release branch, so the new 7.2.2 release that is due pretty soon (end
of the month) should have the fix included. However, the man pages
have not been updated AFAICS.
You can read the thread starting at [1] for some discussion on the
issue. The important issue is that db.connect should not be used for
data import as this sets the database connection for all attribute
tables of vector maps to be created, included of the one imported...
So you should be able to do everything with a single v.in.ogr call,
without db.connect/db.login.
Moritz
[1] https://lists.osgeo.org/pipermail/grass-dev/2017-May/085032.html
Best Regards,
patrick schirmer
#Syntax in the past and still recommended according to manual:
INPATH="PG:dbname=mydatabase schema=myschema"
db.connect driver=pg database=mydatabase schema=myschema #eventially
unnecessary
v.in.ogr input="$INPATH" layer="mytablename" out=mygrasstablename
type="point" -r
#Working code in version GRASS72:
INPATH="PG:dbname=$DB_NAME"
db.connect driver=pg database=mydatabase #no schema required, as it
has to be called inside v.in.ogr
v.in.ogr input="$INPATH" layer="myschema.mytablename"
out=mygrasstablename type="point" -r
#extract of manual:
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
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-user
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-user