Skip to content
knutole edited this page Apr 20, 2016 · 1 revision
# some stats
SELECT rid, band, (stats).*
FROM (SELECT rid, band, ST_SummaryStats(rast, band) As stats
    FROM file_hcsmizjmpftorfzmxxqg CROSS JOIN generate_series(1,3) As band
     ) As foo;


# get list of values and count
SELECT (pvc).*
FROM (SELECT ST_ValueCount(rast) As pvc
    FROM file_hcsmizjmpftorfzmxxqg) As foo
    ORDER BY (pvc).value;

Clone this wiki locally