What tools can I use to view PostGIS raster data?
You can use MapServer compiled with GDAL 1.7+ and PostGIS Raster driver support to view Raster data. In theory any tool that renders data using GDAL can support PostGIS raster data or support it with fairly minimal effort. Again for Windows, Tamas’ binaries http://vbkto.dyndns.org/sdk/ are a good choice if you don’t want the hassle of having to setup to compile your own.