I have a raster which is split into 30 tiles and I want to dump them all into PNGs.
I've read the documentation http://postgis.refractions.net/documentation/manual-svn/RT_ST_AsPNG.html but still don't know how to dump it well.
If i use ST_Histogram, i get numbers, think the raster is well inserted,
SELECT band, (stats).* FROM (SELECT rid, band, ST_Histogram(rast, band) As stats FROM "corine-g100_06-v15" CROSS JOIN generate_series(1,3) As band WHERE rid=2) As foo;