[GIS] Adding raster to PostgreSQL database using raster2pgsql

qgisraster2pgsql

I added a raster to my PG database using the raster2pgsql and when I try to load it from QGIS it says that I need to specify it's geometry. Is that a common problem, and if so, how can I solve it?

The command that I used was

raster2pgsql -s 2100 -c C:\Users\user\Desktop\data\raster_2100.tif public.raster2 | psql -h localhost -U user1 -p

and SELECT * FROM raster_column prints this:

enter image description here

Best Answer

When I first attempted to upload the raster to my database I was convinced that raster2psql was the best way to do that, but I decided to find another way through R, mainly from the library rpostgis, now I haven't solved it using raster2psql but because I am working with R as well, I have to say that the command pgWriteRast does the same work.

Related Question