ST_Height — Returns the height of the raster in pixels.
integer ST_Height(raster  rast);
Returns the height of the raster.
SELECT rid, ST_Height(rast) As rastheight
FROM dummy_rast;
 rid | rastheight
-----+------------
   1 |         20
   2 |          5