On Tue, 30 Oct 2018, Rich Shepard wrote:
I was thinking of working within grass rather than at the bash prompt.
You're right: I know the difference between double and single quotes but
blew it on this instance.
I'm still missing something.
From the grass shell the command, db.connect driver=pg
database=willamette_river_hg, apparently completes because there's no
warning or error displayed.
However, the db.copy command still cannot find the database:
GRASS 7.7.svn (willamette_basin):~/data/grassdata/willamette_basin > db.copy from_driver=sqlite
from_database="$HOME/data/grassdata/willamette_basin/mercury/sqlite/sqlite.db"
from_table=all_species to_driver=pg to_database="willamette_river_hg" to_table=all_species.pg
DBMI-PostgreSQL driver error:
Connection failed.
FATAL: database "willamette_river_hg" does not exist
DBMI-PostgreSQL driver error:
Connection failed.
FATAL: database "willamette_river_hg" does not exist
WARNING: Unable to open database <willamette_river_hg> by driver <pg>
no database is open
no database is open
WARNING: Copy table failed
I access the database with psql from the bash prompt with no issues:
$ psql willamette-river-hg
psql (10.3)
Type "help" for help.
willamette-river-hg=#
Germane to quotation marks, the examples on the db.copy page use both,
sometimes in the same example.
Regards,
Rich
_______________________________________________
grass-user mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/grass-user
