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

2018-07-03 Thread Paul Shapley
Hi Marcus, In the end i just removed the details in the 'VAR' file and saved it and it now defaults back to sqlite. Many thanks everyone for your help as always. On 3 July 2018 at 07:48, Markus Metz wrote: > > > On Tue, Jul 3, 2018 at 8:09 AM, Moritz Lennert < > mlenn...@club.worldonline.be>

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

2018-07-03 Thread Markus Metz
On Tue, Jul 3, 2018 at 8:09 AM, Moritz Lennert wrote: > > > > Am 2. Juli 2018 21:06:15 MESZ schrieb Markus Metz < markus.metz.gisw...@gmail.com>: > >On Mon, Jul 2, 2018 at 4:54 PM, Moritz Lennert > > > >wrote: > >> > >> Le Mon, 2 Jul 2018 16:36:30 +0200, > >> Markus Metz a écrit : > >> > >> > On

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

2018-07-03 Thread Moritz Lennert
Am 2. Juli 2018 21:06:15 MESZ schrieb Markus Metz : >On Mon, Jul 2, 2018 at 4:54 PM, Moritz Lennert > >wrote: >> >> Le Mon, 2 Jul 2018 16:36:30 +0200, >> Markus Metz a écrit : >> >> > On Mon, Jul 2, 2018 at 4:04 PM, Paul Shapley >> > wrote: >> > > >> > > Hi Markus, >> > > >> > > Used

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

2018-07-02 Thread Markus Metz
On Mon, Jul 2, 2018 at 4:54 PM, Moritz Lennert wrote: > > Le Mon, 2 Jul 2018 16:36:30 +0200, > Markus Metz a écrit : > > > On Mon, Jul 2, 2018 at 4:04 PM, Paul Shapley > > wrote: > > > > > > Hi Markus, > > > > > > Used 'db.connect' driver=sqlite > >

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

2018-07-02 Thread Markus Metz
On Mon, Jul 2, 2018 at 4:36 PM, Markus Metz wrote: > > > > On Mon, Jul 2, 2018 at 4:04 PM, Paul Shapley wrote: > > > > Hi Markus, > > > > Used 'db.connect' driver=sqlite database=$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db > > > > I had to delete 'database schema=grass_gis' > > > > I had

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

2018-07-02 Thread Moritz Lennert
Le Mon, 2 Jul 2018 16:36:30 +0200, Markus Metz a écrit : > On Mon, Jul 2, 2018 at 4:04 PM, Paul Shapley > wrote: > > > > Hi Markus, > > > > Used 'db.connect' driver=sqlite > database=$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db > > > > I had to delete 'database schema=grass_gis' > > > >

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

2018-07-02 Thread Markus Metz
On Mon, Jul 2, 2018 at 4:04 PM, Paul Shapley wrote: > > Hi Markus, > > Used 'db.connect' driver=sqlite database=$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db > > I had to delete 'database schema=grass_gis' > > I had to delete 'default group=postgis_reader' That seems to be a bug in

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

2018-07-02 Thread Paul Shapley
Hi Markus, Used 'db.connect' driver=sqlite database=$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db *I had to delete* 'database schema=grass_gis' *I had to delete* 'default group=postgis_reader' Then 'RUN' output:- (Mon Jul 02 14:59:21 2018) db.connect (Mon Jul 02 14:59:22 2018) Command

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

2018-07-02 Thread Markus Metz
On Mon, Jul 2, 2018 at 3:25 PM, Paul Shapley wrote: > > Hi Markus, > > I used 'db.connect' which flags/options did you use? > followed by 'db.login' you don't need db.login for sqlite > > Please see below:- > > db.connect -p > driver: sqlite > database:

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

2018-07-02 Thread Paul Shapley
Hi Markus, I used 'db.connect' followed by 'db.login' Please see below:- db.connect -p driver: sqlite database: C:\\TempLocation\PERMANENT\sqlite\sqlite.db schema: grass_gis group: postgis_reader (Mon Jul 02 14:17:04 2018) Command finished (0 sec) db.connect -d Default driver / database set

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

2018-07-02 Thread Markus Metz
On Mon, Jul 2, 2018 at 2:00 PM, Paul Shapley 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

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

2018-07-02 Thread Paul Shapley
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