[GRASS-dev] [GRASS GIS] #578: quote column names to avoid SQL reserved word collision

[GRASS GIS]

#578: quote column names to avoid SQL reserved word collision
---------------------------+------------------------------------------------
 Reporter:  hamish         |       Owner:  grass-dev@…              
     Type:  enhancement    |      Status:  new                      
 Priority:  minor          |   Milestone:  7.0.0                    
Component:  Vector         |     Version:  svn-develbranch6         
 Keywords:  v.in.ogr, SQL  |    Platform:  All                      
      Cpu:  All            |  
---------------------------+------------------------------------------------

Comment(by mlennert):

 Replying to [ticket:578 hamish]:

 > suggestion by rouault:
 > "''There is no reason for the GPX driver not to use "time" as a field
 name. I think you should report it rather to the GRASS project. They
 should likely quote the field names (provided that it supports that). This
 is what the PG and MySQL driver in OGR do, so you can use any name, even
 if it is a SQL reserved keyword.''"
 >
 >
 >
 > comments?


 IMHO, quoting of field names is good practice in general, and so should be
 implemented in GRASS is possible.

 Moritz

-- 
Ticket URL: <https://trac.osgeo.org/grass/ticket/578#comment:2>
GRASS GIS <http://grass.osgeo.org>