[postgis-users] extraction of pixel from raster

Pierre Racine Pierre.Racine at sbf.ulaval.ca
Wed Apr 11 06:59:47 PDT 2012

You will have to work with ST_Reclass().

See the doc:


and mostly the third example.


> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of jyoti gajrani
> Sent: Wednesday, April 11, 2012 7:36 AM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] extraction of pixel from raster
> hello
> can anybody plz help me in solving my problem --
> I hv imported a raster in POSTGIS2.0 in a table.
> now i want to extract all pixels with only particular color like blue or some
> specific from that.
> how can i do that?
> Jyoti

More information about the postgis-users mailing list