ST_PixelAsPoint — Returns a point geometry of the pixel's upper-left corner.
geometry ST_PixelAsPoint(raster  rast, integer  columnx, integer  rowy);
Returns a point geometry of the pixel's upper-left corner.
Disponibilità: 2.1.0
SELECT ST_AsText(ST_PixelAsPoint(rast, 1, 1)) FROM dummy_rast WHERE rid = 1;
   st_astext
----------------
 POINT(0.5 0.5)