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:
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 libraryrpostgis
, now I haven't solved it usingraster2psql
but because I am working with R as well, I have to say that the commandpgWriteRast
does the same work.