I have successfully loaded a large number of .asc images (>2800 200x200 tiles) into a Postgres table with PostGIS 2.1 support. The new table appears in QGIS's DB Manager and I can add the whole image as a single layer.
Is there a way, for example, to create an SQL script on raster tables and display the result in QGIS as a raster layer as you might with a vector layer? Or simply to filter the table to specific tiles.
Within QGIS, the DB Manager allows me to load the whole table but doesn't seem to support filtering of the table, and neither does right clicking on the layer once its loaded.
This is my first foray into PostGIS and rasters so the answer may be obvious so please have patience with me.