I loaded a tif-file of some soil data into postgres with:
raster2pgsql -c -I -F -C -r -M -s 31467 -t 200x200 soil_file.tif gis.soil_map | psql -U user -d database -h localhost -p 5432
which worked perfectly fine. The tif itself shows data when imported in QGIS and also the the imported raster from my database shows its values in QGIS.
Here my problem:
But when I want to query my raster within my database the query is always empty:
SELECT rid, (ST_SummaryStats(rast, 1)).* from gis.soil_map
and I have absolutely no idea what could cause this. The same procedure work fine with a different raster from a different source, so I think this might have to do with the file, but as I said, no idea what to look for.