I am quite new to this process (using raster data in PostGIS) and tried to find some tips/solutions on other threads but I didn't manage to get things working.
I ingested some Landsat data into my database using:
raster2pgsql -I -C -s 28356 LS7_20150425_B50.tif public.LS7_20150425_B50 | psql –d postgres –U postgres
And everything is working fine : I see my new table LS7_20150425_B50 with two columns (rid and rast) and I am able to compute some stats on my raster using ST_SummaryStats().
However, I'd like to display my raster in QGIS (2.12.0 Lyon) using the DB Manager. However, when I am adding the table to the canvas I am getting an error message:
PG: dbname=postgres host=localhost user=postgres port=9999 mode=2 schema=public column=rast table=ls7_etm_nbar_p54_ganbar01-002_089_078_20150425_b40 is not a valid layer.
Do you have any idea?