Hi Rich, to connect the database tabel to your map you have to specify the postgres connection with v.db.connect as well:
v.db.connect map=stations driver=pg database="host=localhost,dbname=willamette-river-hg" table=<NameOfTheTable> key=<NameOfTheCatColumn> Consider that the <NameOfTheTable> have to be different from the name of the mapset, i.e. must not be called "stations"! Regards. Stefan > Rich Shepard <[email protected]> hat am 8. November 2018 um 15:07 > geschrieben: > > > On Thu, 8 Nov 2018, [email protected] wrote: > > > if you use a postgres database (driver=pg) you have to specify the full > > connection string to the database. You can see this in the manual for > > db.connect (look for PostgreSQL): > > Stefan, > > Each time I think that I have the path requirement differences between > db.connect and v.db.connect understood there's aninstance when I mix them up > unintentionally. I've changed the db.connect line in the script to use > localhost rather than the absolute path. > > As I responded to Markus M, I don't know how to fix the absolute path > returned by v.db.connect > > > db.connect driver=pg database="host=localhost,dbname=willamette-river-hg" > > > db.connect -p > driver: pg > database: host=localhost,dbname=willamette-river-hg > schema: > group: > > > v.db.connect -p map=stations > Vector map <stations> is connected by: > layer <1/stations> table <stations> in database > </home/rshepard/data/grassdata/willamette_basin/willamette-river-hg> through > driver <pg> with key <cat> > > Trying again: > > > db.connect driver=pg > > database=$HOME/data/grassdata/willamette_basin/willamette-river-hg > > > v.db.connect -p map=stations > Vector map <stations> is connected by: > layer <1/stations> table <stations> in database > </home/rshepard/data/grassdata/willamette_basin/willamette-river-hg> through > driver <pg> with key <cat> > > What am I still doing incorrectly with db.connect? > > Thanks, > > Rich > _______________________________________________ > grass-user mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/grass-user _______________________________________________ grass-user mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/grass-user
