[mapserver-users] Mapserver/PostGIS map file problem (double quotes in layer 'DATA' element)

[Adam Eskreis]

You could try regex

\"Area\"

-Adam

On Wed, May 27, 2009 at 6:48 PM, Peter Willis <peterw at borstad.com> wrote:

>
> Hello,
>
> I am having a problem serving a PostGIS layer via mapserver
> as WFS.
>
> The problem arises from the generation/use of column names
> in PostgreSQL that require double quotes.
>
> ie:
>
>  SELECT oid,gid, the_geom, "Area","Perimeter","PixelValue" FROM
> global_Land_poly WHERE "PixelValue"=1;
>
>
>
> In the map file the 'DATA' member of the PostGIS layer is defined as:
>
> DATA "the_geom from (select oid,gid, the_geom, Area,Perimeter,PixelValue
> FROM global_Land_poly WHERE PixelValue=1 ) AS FOO using SRID=4326"
>
>
> <ERR>Mapserver relays a PostGIS error from PostgreSQL:
> 'ERROR:  column "area" does not exist...</ERR>
>
> This is because the column name is actually "Area"
> and requires quotes.
>
> How do I define double quotes in my PostGIS query
> within the 'DATA' element of my mapfile layer?
>
> Thanks for any enlightenment,
>
> Peter
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090527/3e15e921/attachment.htm>