I have inserted a Landsat raster into PostGIS using the command :
raster2pgsql -I -C -s 28356 -M -t 100x100 /data/LS7_20150425_B40.tif public.red | psql -d postgres -U postgres
Using QGIS, I have opened both my original file and the raster from PostGIS using DB manager of QGIS.
According to QGIS the pixel values are not the same :
- original file : values from 64 to 3687
- raster from PostGIS : values from 10 to 8295
Note: if I export my raster from PostGIS to a new file using GDAL, the file is identical to the original one.
Any explanation about this difference ?