[mapserver-users] escape double quotes in data option

[John Pulles]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080815/aafa2b87/attachment.htm>