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.
On May 19, 2014 at 3:54:36 PM, Bborie Park ([email protected]) wrote: 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 -- 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.
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
