[GRASS-user] Switching databases for holding attributes in Grass 7.4.1

[Markus Metz]

On Mon, Jul 2, 2018 at 2:00 PM, Paul Shapley <p.shapley at gmail.com> wrote:
>
> Hi Users,
>
> I want to use 'r.to.vect' but it seems to default to a 'Postgis' table
that has no geometry column just a table with a 'cat' id. I would like to
export to 'sqlite'. I have both postgres an sqlite login details stored in
'db.login'. How do i switch between the two or at least make sqlite the
default? If I change settings with 'db.connect' to 'sqlite'

what is the exact command you used to set the default connection to sqlite?

You can also try db.connect -d, otherwise you might need to specify the
default database to be used.

In any case, please verify first with db.connect -p to see the connection
details used when creating a new vector.

Markus M

> it fails (error below) but still keeps holding onto the 'grass_gis'
schema form the Postgis connection!
>
> r.to.vect
input=APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs at PERMANENT
output=test1 type=area
> DBMI-SQLite driver error:
> Error in sqlite3_prepare():
> unknown database grass_gis
> DBMI-SQLite driver error:
> Error in sqlite3_prepare():
> unknown database grass_gis
> ERROR: Unable to create table: create table grass_gis.test1 ( cat
integer, value integer, label varchar(10))
> WARNING: Table <grass_gis.test1> linked to vector map <test1> does not
exist
>
> Is there a preferred option to change databases more cleanly.
>
> Many thanks,
>
>
> --
> Paul J. Shapley MSc CGeog (GIS) FRGS
>
>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/grass-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20180702/fb182b65/attachment-0001.html>