You can place rasters into a single raster using ST_BAND. If you are familiar with rasters this will make a multispectral raster. I don't believe there is a limit to the bands as I have added over 50. To make the multispectral raster your other rasters (matrices) will need to be the same cell size and alignment.
You might try http://www.gdal.org/gdal_merge.html (using the -separate) This will create a 2 banded raster in postgis ST_AddBand(ST_MakeEmptyraster(layers.modis_rast),ARRAY[layers.modis_rast, layers.stack_rast]) as rast On Fri, Aug 1, 2014 at 6:42 AM, Darrel Maddy <darrel.ma...@newcastle.ac.uk> wrote: > Dear all, > > > > I am just reacquainting myself with postgres and postgis and trying to > decide how best to store the output from my model (large matrices stored in > gtiff format). I really want to store multiple rasters in one table but > when I try to visualise these in QGIS (via an sql extract in dbmanager > using import to new layer) nothing happens. I can add one raster per table > to the canvas but I do not want thousands of tables. Will the dbmanager > sql add layer work with rast as a geometry? > > > > I suspect this is simple, but it eludes me at present. > > > > Thanks in anticipation of your help. > > > > Darrel > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users