[Qgis-user] PyQGIS to add PostGIS raster layer?

[Yann Voté]

Sorry, I read too fast. Didn't see it was about raster layers.

But here is a clue : load the raster layer manually, then look at the 
tooltip appearing when you hover the cursor on the layer. It will 
contain the connection string.


Le 30/04/2020 à 09:45, Yann Voté a écrit :
> Hi,
> 
> Something like this should do.
> 
> pg_layer = QgsVectorLayer(
>      "host=db.priv.example.org port=5432 authcfg=expauth srid=4326 "
>      "dbname=exampledb table='schema'.'table_name' (geometry) "
>      "type=MULTIPOLYGON sql=",
>      baseName='table_name',
>      providerLib='postgres',
> )
> QgsProject.instance().addMapLayer(pg_layer)
> 
> Of course, adapt with your values. In particular, authcfg is the 7-chars 
> identifier of the auth configuration that contains your login and 
> password (or cert) to authenticate to PostgreSQL.
> 
> See https://qgis.org/pyqgis/master/core/QgsVectorLayer.html
> 
> See also 
> https://qgis.org/pyqgis/master/core/QgsDataSourceUri.html#qgis.core.QgsDataSourceUri 
> for more options to build database connection strings.
> 
> Regards.
> 
> Yann
> 
> 
> Le 30/04/2020 à 00:24, thayeray a écrit :
>> Is it possible to add a PostGIS raster layer to a project using PyQGIS?
>> The PyQGIS Developer Cookbook mentions adding rasters from files,
>> geopackages and WCS services.
>> If I try using a QgsDataSourceUri by feeding it a raster column 
>> instead of a
>> geometry column, the PostGIS error that is generated shows that is not 
>> going
>> to work because raster is not a geometry:
>> WARNING    Erroneous query: SELECT 0, array_agg(DISTINCT
>> st_srid("rast")::text || ':' || UPPER(geometrytype("rast"))) FROM
>> "public"."indicators__g_economic_rebal_r_62ft" returned 7 [ERROR: 
>> function
>> geometrytype(raster) does not exist
>>
>> Any ideas of what I can do? Do I just have to give up on PostGIS 
>> rasters and
>> just turn it into WCS on the server?
>>
>>
>>
>>
>> -- 
>> Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user