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

[Germán Carrillo]

Exactly Richard, that would be the expected behaviour.

Regards,

Germán

2014-12-10 4:37 GMT-05:00 Richard Duivenvoorde <rdmailings at duif.net>:

> 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
>



-- 
-----------
   |\__
(:>__)(
   |/

Soluciones Geoinformáticas Libres
http://geotux.tuxfamily.org/
http://twitter.com/GeoTux2
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20141210/eddcf118/attachment.html>