You could try regex \"Area\"
-Adam On Wed, May 27, 2009 at 6:48 PM, Peter Willis <pet...@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@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users >
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users