Under Qgis 1.8 on Windows 7 I have this problem with my pyArchInit plugin: I need to load on the map canvas my geometries from a postgis layer. Till the 1.7.4 version I use the method explained on the tutorial.
But I have to load also some potgres view, and Qgis 1.8 need to know the column that I would like to use as ID.
How can I pass this value with pyQgis and restore my plugin?
Thanks a lot for any help!
uri = QgsDataSourceURI() # set host name, port, database name, username and password uri.setConnection("localhost", "5432", "dbname", "johny", "xxx") # set database schema, table name, geometry column and optionaly subset (WHERE clause) uri.setDataSource("public", "roads", "the_geom", "cityid = 2643") vlayer = QgsVectorLayer(uri.uri(), "layer_name_you_like", "postgres")