This function returns the statistics about a band of a raster object in JSON format. If the band does not have statistics, the function returns null.

Syntax

text ST_Statistics(raster raster_obj, integer band);

Parameters

Parameter Description
raster_obj The raster object.
band The sequence number of the band, which starts from 0.

Examples

select ST_Statistics(raster_obj, 0) from raster_table where id=1;

__________________________________
'{    "min" : 0.00, "max" : 255.00,"mean" : 125.00,"std" : 23.123,"approx" : false}'