ST_SetUpperLeft — Sets the value of the upper left corner of the pixel of the raster to projected X and Y coordinates.
raster ST_SetUpperLeft(raster  rast, double precision  x, double precision  y);
Set the value of the upper left corner of raster to the projected X and Y coordinates
SELECT ST_SetUpperLeft(rast,-71.01,42.37)
FROM dummy_rast
WHERE rid = 2;