[postgis-users] Problem to visualize raster data from PostGIS in QGIS

[Roberto Lazarte Kaqui]

I have two multiband raster files and i'm trying to load these data into PostGIS using "raster2pgsql".
Here is the syntax that i used:

raster2pgsql -c -s 4326 -I -t 100x100 *.tif  public.deforested_rasters | psql -d r342471958


It works without error, but i don't know if the command loads correctly both raster files. The database in PostGIS has two columns, one with the spatial index and the other one with raster information. I'm trying to visualize the resultant database in QGIS, but for some reason it doesn't open the raster layer.

I've tried to solve this problem using this idea: https://duncanjg.wordpress.com/2012/11/20/the-basics-of-postgis-raster/, transforming the raster data to geometry data through DB manager using this command:

select rid,rast::geometry from deforested_rasters


but when visualized in QGIS, only returns a rectangular area without the original characteristics.

Any ideas of how can i confirm that the "raster2pgsql" command loads correctly the raster files? Or a different way to load these data into PostGIS?

The raster files are available in:https://www.dropbox.com/sh/nu8nl6cigv8viz1/AADTrr_w8SCstDHOu6AiGeJta?dl=0

Thanks,
Roberto

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150331/967e09ab/attachment.html>