I have several raster images of temperature, they are stored as geotiffs and I import them to a postgres database using raster2pgsql.
raster2pgsql -s $SRID -t auto -I $file $SCHEMA.$(basename $file .tiff) | psql -U $USERNAME -d $DATABASE -h $HOST -p $PORT
But when I look at the data using pgadmin I see only an ID and rast column and no temperature values.
Using qgis I can display original geotiff without any problems. Any idea what is going wrong?