[GRASS-user] Rename multiple sqlite columns at once

[Nikos Alexandris]

On Fri, 2008-11-07 at 01:38 +0100, Moritz Lennert wrote:
> You still use quotes:
> tempcolumn="$tempcolumn\_tmp"
> 
> IIUC, the quotes will let the slash appear literally. So, just leave
> out 
> the quotes as follows:
> 
> tempcolumn=$tempcolumn\_tmp
> 
> However, as you say your original script (in my modified form)
> actually 
> worked, it just spit out a series of warnings. So it might be more 
> interesting to check upon these warnings. I only saw these with the 
> sqlite driver, not with dbf or postgresql, so we should try to find
> out 
> what happens  with that driver.
> 
> Moritz

Oh, sorry Moritz. Now I see. I am at your service :-) Tell me what/how
to test?

At a glance:

* I have a shapefile with more than 30 columns (the test shapefile is
just a test).

* I imported in GRASS (using sqlite backend).

* sqlitebrowser reports "correct" column types (integere, double
precision, varchar)

* db.describe reports columnt type with CAPS and CHARACTER instead of
varchar