[gdal-dev] Fwd: ogr2ogr. SQL seems to disable use_gpx_extensions

Even Rouault even.rouault at spatialys.com
Fri Sep 12 11:53:04 PDT 2014


Le vendredi 12 septembre 2014 20:35:34, Pedro Machado Monteiro a écrit :
> Thank you very much, Even.
> 
> By the way, unlike the alias for the tag <*cmt*>, the alias for the tag <
> *desc*> gave me a syntax error in the SQL:

Yes, DESC is a SQL reserved keyword to ask for descending sorting order. When 
you want to use it as an identifier, it must be quoted, e.g. with single quote 
character

 "SELECT Linha AS name , IDENTIFICA AS 'cmt' FROM FaunaPnpg_wgs84_teste_utf8"

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com


More information about the gdal-dev mailing list