<div dir="ltr">raster2pgsql does not create a "geom" column. You should consider tiling your rasters though with -t WIDTHxHEIGHT.<div><br></div><div>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...</div>
<div><br></div><div>SELECT (ST_SummaryStats(rast)).* FROM public.srtm_test</div><div><br></div><div>Compare the stats with that from</div><div><br></div><div>gdalinfo --stat C:\picardie-nature\Stage\Qgis\Alti\srtm\srtm_37_02.tif</div>
<div><br></div><div>-bborie</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, May 19, 2014 at 2:26 PM, dandrigo <span dir="ltr"><<a href="mailto:lcelati@latitude-geosystems.com" target="_blank">lcelati@latitude-geosystems.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Dear all,<br>
<br>
I tried to import via pgraster2pgsql several DEM raster files.<br>
<br>
Below, i paste a screenshot representing my DOS interface :<br>
<br>
SS_pg_raster.JPG<br>
<<a href="http://postgis.17.x6.nabble.com/file/n5006344/SS_pg_raster.JPG" target="_blank">http://postgis.17.x6.nabble.com/file/n5006344/SS_pg_raster.JPG</a>><br>
<br>
<br>
After the import, it's impossible to visualize the postgis raster layer via<br>
qgis. And via qgis db manager or pgadmin3, we can notice thaht the import<br>
did not create a geom column. Via qgis db manager, no overview of the layer<br>
is visible.<br>
<br>
Below the qgis db manager showing the characteristic of this layer :<br>
<br>
qgis_dbmanager.JPG<br>
<<a href="http://postgis.17.x6.nabble.com/file/n5006344/qgis_dbmanager.JPG" target="_blank">http://postgis.17.x6.nabble.com/file/n5006344/qgis_dbmanager.JPG</a>><br>
<br>
<br>
I'm working with windows 8 with postgres 9. and postgis 2.1<br>
In advance thank you t othrow light for me.<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://postgis.17.x6.nabble.com/Problem-with-postgis-raster-tp5006344.html" target="_blank">http://postgis.17.x6.nabble.com/Problem-with-postgis-raster-tp5006344.html</a><br>
Sent from the PostGIS - User mailing list archive at Nabble.com.<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</blockquote></div><br></div>