[postgis-users] [OT] multiple rasters in same table?

Raffaele Morelli raffaele.morelli at gmail.com
Wed Nov 5 04:19:24 PST 2014

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 »

More information about the postgis-users mailing list