On Tue, 6 Nov 2018, Markus Metz wrote:
Please check v.db.connect map=stations -p
and
db.connect -p
Is the table attached to the map stations really in the default database?
Markus M,
When I run db.colums without specifying the driver does grass display the
columns in the sqlite or postgres table?
db.columns table=stations
site_nbr
site_name
lon
lat
easting
northing
start_date
end_date
howmany
bin_col
Adding the driver 'sqlite' suggests that db.columns sees the postgres
table:
db.columns table=stations driver=sqlite
WARNING: Table <stations> not found in database <willamette-river-hg> using
driver <sqlite>
So, if the db.* modules look in the postgres database tables, why does the
v.db.* modules look in the sqlite table instead? And, trying to rewire the
attribute table for the stations map from sqlite to postgres fails:
v.db.connect map=stations driver=pg table=stations -o
ERROR: Column <cat> not found in table <stations>
All suggestions welcome.
Regards,
Rich
_______________________________________________
grass-user mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/grass-user
