PostGIS - ExecuteSQLQuery result with uppercase column names

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

PostGIS - ExecuteSQLQuery result with uppercase column names

Andreas Morf

Hello

When using FeatureService::ExecuteSQLQuery through Java-API to access PostGIS backend the resulting property names provided by MgSqlDataReader are always upper case – within Postgresql/PostGIS I consequently use lowercase table- and column names. This is very uncomfortable when programming generic interfaces/data-viewers.

 

Is this a desired behavior of the PostGIS-FDO driver?

 

The code this conversion takes place is within Providers\GenericRdbms\Src\Gdbi\GdbiQueryResult.cpp on line 147:

 

                 colInfo->name[i] = towupper(colName[i]);

 

Thanks for any feedback!

Andreas


_______________________________________________
fdo-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/fdo-users