[postgis-users] what is the query to build a multi band raster table from existing raster table of bands?

[Pierre Racine]

I feel like I'm responding to a question generator bot.... :-(

Try something like:

CREATE newtable AS
SELECT ST_AddBand(ST_Band(table1.rast, 1), ST_Band(table2.rast, 1)) rast
FROM table1, table2
WHERE table1.rid = table2.rid

Pierre

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Zelio Fernandes
> Sent: Thursday, February 16, 2012 6:35 AM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] what is the query to build a multi band raster table from
> existing raster table of bands?
> 
> what is the query to build a multi band raster table from existing raster table of
> bands?
> 
> --
> View this message in context: http://postgis.17.n6.nabble.com/what-is-the-
> query-to-build-a-multi-band-raster-table-from-existing-raster-table-of-bands-
> tp4475646p4475646.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users