[GRASS-user] Workaround for temporary table with SQL keywords as column names

[Vaclav Petras]

Hi Luí­s,

On Thu, Nov 4, 2021 at 12:52 PM Luí­s Moreira de Sousa via grass-user <
grass-user at lists.osgeo.org> wrote:

>
> To the question: is there a workaround for this problem? Can GRASS be
> instructed to not use SQL keywords as column names? Or somehow create valid
> SQL queries, for instance using double quotes?
>

Not an overall solution, but v.to.lines module/tool is written Python, so
adding an option which would be a prefix for names for all new columns
would be fairly straightforward.

https://github.com/OSGeo/grass/blob/main/scripts/v.to.lines/v.to.lines.py

The SQL keywords issue is not resolved, but a couple things here and there
could make it less of an issue. You can see part of the discussion in #653:

https://github.com/OSGeo/grass/commit/ff33a47ec7608d3be7116df11de8b0b4b186c654

Best,
Vaclav
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20211118/d6915352/attachment-0001.html>