Load a table with NO geometry_column using PyQGIS

Question

I had to backup a PostGIS model in a geopackage and I wonder how to load a non-spatial table, aka a table with NO geometry_column.

aurel_nc · Accepted Answer

Just had to write None instead of the geometry_column name in the setDataSource method.
uri = QgsDataSourceUri()
uri.setConnection("MyServerAdress", "5432", "myBase", "user", "pass")
uri.setDataSource(schema, table, None)
layer = QgsVectorLayer(uri.uri(False), table, "postgres")
QgsProject.instance().addMapLayer(layer)

Load a table with NO geometry_column using PyQGIS

One Answer

Add your own answers!

Ask a Question