[Qgis-developer] [Qgis-user] How load Postgis layer from command line?

[Richard Duivenvoorde]

On 10-12-14 10:11, Uggla Henrik wrote:
> In Linux it is very easy to setup a ramdisk for fast temporal file storage.
> 
> --help really gives the impression that loading Qgis with PostGIS layers using the FILE parameter is a breeze. Also, I still doesn't get what this "PostGIS extension" mentioned in --help is.

cc'ing to dev list, original thread here:

http://lists.osgeo.org/pipermail/qgis-user/2014-December/030180.html


Me neither, best to bring this to the dev list then, to ask which this
extension is.

And IF we want a FILE parameter work for postgis we could come up with a
design for that file param and do a feature request to get this implemented?

For example, as this works:

l = iface.addVectorLayer('dbname=bag host=localhost port=5432 user=geo
password=xxx sslmode=disable key=gid estimatedmetadata=true srid=28992
type=MULTIPOLYGON table="bag8mrt2014"."provincie" (geovlak) sql=',
"test", "postgres")

this is the actual uri:

'dbname=bag host=localhost port=5432 user=geo
password=xxx sslmode=disable key=gid estimatedmetadata=true srid=28992
type=MULTIPOLYGON table="bag8mrt2014"."provincie" (geovlak) sql='

so maybe prepend that with the provider part:

postgres:'dbname=bag host=localhost port=5432 user=geo
password=xxx sslmode=disable key=gid estimatedmetadata=true srid=28992
type=MULTIPOLYGON table="bag8mrt2014"."provincie" (geovlak) sql='

and add a --uri option to QGIS?

qgis --uri postgres:'dbname=bag host=localhost port=5432 user=geo
password=xxx sslmode=disable key=gid estimatedmetadata=true srid=28992
type=MULTIPOLYGON table="bag8mrt2014"."provincie" (geovlak) sql='

or something like that?

Regards,

Richard Duivenvoorde