Re: QGIS Loads Black Screen For PostGIS Out-Db Raster Data

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(dot)gis(at)gmail(dot)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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>>
>
>