Hi list,
I would like to define a map file layer with data coming from postgis and
containing a (double) quoted postgis field and single quoted literals.
For example:
DATA "way from (select * from planet_osm_polygon where
landuse='reservoir' or landuse='water' or "natural" in
('lake','water','land') order by z_order) as water using unique osm_id using
srid = 28992"
Reversing the single and double quotes does not work since postgresql needs
double quotes around the "natural" column name. Doubling the quotes or using
a back-slash does not work. Is it possible to escape double quotes in a map
file?
Thanks,
John
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
