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

[Paragon Corporation]

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: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Raffaele Morelli
Sent: Wednesday, November 05, 2014 4:03 AM
To: postgis-users at lists.osgeo.org
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 <raffaele.morelli at gmail.com>:
> > 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
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users