raster2pgsql does not create a "geom" column. You should consider tiling your rasters though with -t WIDTHxHEIGHT.
As for visualizing with QGIS, I have no suggestions. You can do a quick spot-check that the data is present and valid in PostGIS though... SELECT (ST_SummaryStats(rast)).* FROM public.srtm_test Compare the stats with that from gdalinfo --stat C:\picardie-nature\Stage\Qgis\Alti\srtm\srtm_37_02.tif -bborie On Mon, May 19, 2014 at 2:26 PM, dandrigo <[email protected]>wrote: > Dear all, > > I tried to import via pgraster2pgsql several DEM raster files. > > Below, i paste a screenshot representing my DOS interface : > > SS_pg_raster.JPG > <http://postgis.17.x6.nabble.com/file/n5006344/SS_pg_raster.JPG> > > > After the import, it's impossible to visualize the postgis raster layer via > qgis. And via qgis db manager or pgadmin3, we can notice thaht the import > did not create a geom column. Via qgis db manager, no overview of the layer > is visible. > > Below the qgis db manager showing the characteristic of this layer : > > qgis_dbmanager.JPG > <http://postgis.17.x6.nabble.com/file/n5006344/qgis_dbmanager.JPG> > > > I'm working with windows 8 with postgres 9. and postgis 2.1 > In advance thank you t othrow light for me. > > > > -- > View this message in context: > http://postgis.17.x6.nabble.com/Problem-with-postgis-raster-tp5006344.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
