I forgot to mention that I have put the question on the qgis-user mailing list. Thanks for your help.
On Tue, Apr 18, 2017 at 3:31 PM, Osahon Oduware <osahon....@gmail.com> wrote: > Hi Adrian, > > I think it is a problem with QGIS as things seems fine from the PostGIS > end (raster data) going by the following queries: > > *SELECT r_table_name, r_raster_column, out_db FROM raster_columns;* > returned the following output: > "test_rast","rast","[True, True, True]" > > *SELECT t.rid, (md).isoutdb, (md).path* > *FROM test_rast AS t, ST_BandMetaData(t.rast) AS md* > *limit 1;* > returned the following output: > 1,True,"/home/nagispg/local/src/SID_Test/rast_1.sid" > > *SELECT ST_Width(rast) wdth, ST_Height(rast) hgt* > *FROM test_rast;* > returned the following output: > 10000,7000 > > The "Add to canvas" menu is a pop-up that is displayed when you > right-click on the raster table from the DB Manager Menu (Database => DB > Manager => DB Manager) > > On Tue, Apr 18, 2017 at 3:03 PM, Adrian Klaver <adrian.kla...@aklaver.com> > wrote: > >> On 04/18/2017 06:41 AM, Osahon Oduware wrote: >> >>> Hi All, >>> >>> I have an out-db raster on PostGIS which I tried to load in QGIS (v >>> 2.14.12-Essen) utilizing the DB Manager to establish a connection. I >>> could view the raster table, but when I try to "Add to canvas" it >>> displays a black screen instead of the raster image. >>> >> >> There is data in the table? >> >> I am not that familiar with GIS, much less QGIS. Still a quick look at >> the docs found this: >> >> http://docs.qgis.org/2.14/en/docs/user_manual/working_with_r >> aster/supported_data.html#what-is-raster-data >> >> I see Add Raster layer, nothing about Add to canvas. >> >> If the above does not answer the question I would say you will have a >> better chance of getting an answer here: >> >> http://lists.osgeo.org/mailman/listinfo/qgis-user >> >> >> >>> I would be glad if someone could help me to resolve this. >>> >> >> >> -- >> Adrian Klaver >> adrian.kla...@aklaver.com >> > >
