I haven't tried to do this in a while in mapserver, but as I recall, I think you can escape the quotes.
Try DATA "PG:host=localhost dbname='xxx' user='xxxx' password='xxx' schema='dtms' table='dtm' where='filename=\'dtm1.tif\'' mode='2'" Hope that helps, Regina http://www.postgis.us -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Raffaele Morelli Sent: Wednesday, November 05, 2014 4:03 AM To: [email protected] Subject: Re: [postgis-users] [OT] multiple rasters in same table? On 31/10/14 at 03:12pm, Mateusz Loskot wrote: > 2014-10-31 15:08 GMT+01:00 Raffaele Morelli <[email protected]>: > > Is there any chance to load multiple rasters in the same table? > > > > Raffaele > > Yes. > Similarly to vector, a raster layer in PostGIS is made of a pair: > table and column, not just a table. > Yes, I finally loaded a bunch of GTiff without applying raster constraints because they have different extents. Now I am stucked in defining a working mapserver LAYER, ie how to query the table according to 'filename' column (added OT in the subject because should be a mapserver related question I guess) Given that layer definition: LAYER NAME "dtm20" DATA "PG:host=localhost dbname='xxx' user='xxxx' password='xxx' schema='dtms' table='dtm' where='filename=dtm1.tif' mode='2'" TYPE RASTER [snip METADATA etc etc] END Then shp2img gives an error, no matter how I use quotes in where condition: msDrawRasterLayerLow(): Unable to access file. Corrupt, empty or missing file 'PG:host='localhost' port='5432' dbname='xxx' user='xxx' password='xxx' schema='dtms' table='dtm' where='filename=dtm1.tif' mode='2'' for layer 'dtm20'. Error browsing database for PostGIS Raster properties <br> Without where condition I obtain an image with all GTiff which is not what I want... Where I am doint wrong? Regards -- < Nunc est bibendum, nunc pede libero pulsanda tellus > _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
