How to export a PostGIS raster to PNG?

Question

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;

Answer 1

Avances,

The output of ST_AsPNG is the binary blob of a PNG file, so you output it to a file as you would any other binary document saved in PostgreSQL . It really depends what you are using as your tool.

For example we have examples of this that output to browser in thsese quick examples we put together to demonstrate how it is done.

http://www.bostongis.com/blog/index.php?/archives/175-Minimalist-Web-based-PHP-PostGIS-2.0-Spatial-GeometryRaster-Viewer.html Download the examples to see.

Only difference in your case is you would output to a file instead ofr browser stream.

You can also do it with plpython, plperl, or any other postgresql pl language that can write to a file if you just want to output to the database server. We'l try to put together examples of that in the next month or so.