<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">In qgis you should be able to go into the DB manger and see the raster tables. From there you can drag and drop onto the canvas. I am on 2.2 (valmiera) and can do this just fine. I *think* things were different in past versions and once there was a plugin for postgis raster support; although its not in the repos any longer. </div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><p style="color:#000;">On May 19, 2014 at 3:54:36 PM, Bborie Park (<a href="mailto:dustymugs@gmail.com">dustymugs@gmail.com</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div><div></div><div>
<title></title>
<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>
_______________________________________________
<br>postgis-users mailing list
<br>postgis-users@lists.osgeo.org
<br>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</div></div></span></blockquote></body></html>
<br>
<p><font face="Arial" size="2">This transmission contains confidential and privileged
information intended solely for the party identified above. If you receive this message in error, you must not use
it or convey it to others. Please destroy it immediately and contact the sender at
(303) 386-3955 or by return e-mail to the sender.</font></p>