ST_NumBands — Returns the number of bands in the raster object.
integer ST_NumBands(raster rast);
Returns the number of bands in the raster object.
SELECT rid, ST_NumBands(rast) As numbands FROM dummy_rast;
rid | numbands ----+---------- 1 | 0 2 | 3