Hi Bernard,
Many thanks works perfectly.
Le lun. 14 oct. 2019 à 16:13, Bernhard Ströbl a
écrit :
> Hi Denis,
>
> I use:
> uri = QgsDataSourceUri()
> uri.setDataSource(schemaName, tableName, geomColumn)
> uri.setConnection(thisHostName,
> str(thisPort), thisDatabaseName,
> "", "",
Hi Denis,
I use:
uri = QgsDataSourceUri()
uri.setDataSource(schemaName, tableName, geomColumn)
uri.setConnection(thisHostName,
str(thisPort), thisDatabaseName,
"", "", QgsDataSourceUri.SslRequire, thisAuthCfgId)
vLayerUri = uri.uri(False)
vlayer = QgsVectorLayer(vLayerUri, displayName,
Hi all,
I add a layer using an authentification config ID using PyQGIS:
uri = QgsDataSourceUri()
uri.setConnection(HOST, PORT, DB, None, None, QgsDataSourceUri.SslPrefer,
pg_auth_id)
In the project, the credentials are written in clear text in the project
file:
dbname='pub'