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

Paragon Corporation lr at pcorp.us
Wed Nov 5 04:01:08 PST 2014

I haven't tried to do this in a while in mapserver, but as I recall, I think
you can escape the quotes.


 DATA "PG:host=localhost dbname='xxx' user='xxxx' password='xxx'
schema='dtms' table='dtm' where='filename=\'dtm1.tif\'' mode='2'"

Hope that helps,

-----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:

        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]

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

Where I am doint wrong?

< Nunc est bibendum, nunc pede libero pulsanda tellus >
postgis-users mailing list
postgis-users at lists.osgeo.org

More information about the postgis-users mailing list