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