On 05/11/14 at 07:01am, Paragon Corporation wrote: > 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'"
Indeed, I was suspicius about that and added a INT column which works, while escaping does not... it complains about a 'filename' column not existing while it's obviosuly there (used -F option in raster2pgsql) 2014-11-05 13:10:26 CET ERRORE: la colonna "filename" non esiste al carattere 257 2014-11-05 13:10:26 CET ISTRUZIONE: select srid, nbband, st_xmin(geom) as xmin, st_xmax(geom) as xmax, st_ymin(geom) as ymin, st_ymax(geom) as ymax from (select srid srid, extent geom, num_bands nbband from raster_columns where r_table_schema = 'raster' and r_table_name = 'shade') foo where filename=shade20_12.tif > > Hope that helps, > Regina > http://www.postgis.us -- « Nunc est bibendum, nunc pede libero pulsanda tellus » _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
