Loading a Postgres view using PyQGIS

Question

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?

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

jef · Accepted Answer · 2012-07-03 14:35:44Z

6

QgsDataSourceURI.setDataSource() has an additional fifth argument to specify the key column.

answered Jul 3, 2012 at 14:35

jef

2,74718 silver badges18 bronze badges

Add a comment |

GeoGyro · Accepted Answer · 2020-10-27 12:53:31Z

2

An update and an explicit example to complete @jef's answer :

uri = QgsDataSourceUri()
uri.setConnection("localhost", "5432", "myDatabase", "myUser", "myPassword")
uri.setDataSource("mySchema", "myTable", "myGeomField", aKeyColumn="myUniqueIdField")
vlayer = iface.addVectorLayer(uri.uri(False), "nameOfMyLayer", "postgres")

Adapt it with your database settings.

Source

answered Oct 27, 2020 at 12:53

GeoGyro

1,7561 gold badge18 silver badges39 bronze badges

Add a comment |

Stack Exchange Network

Loading a Postgres view using PyQGIS

2 Answers 2

Your Answer

Linked

Hot Network Questions

Loading a Postgres view using PyQGIS

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Linked

Related

Hot Network Questions