Good afternoon,

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?


The values are stored in the raster object itself. You can access them using the ST_Value function which accepts column and row indexes or point geometries.

The documentation has some good examples.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.