Finding the name of the geometry column for QgsVectorLayers using PyQGIS

Question

I have a QgsVectorLayer whose data source is a vector GeoPackage file. How can I find the name of its geometry column?

It is possible to use ogr to get it, but I am looking for a native PyQGIS approach without additional imports or separately loading the dataset again.

Answer 1

You need to use QgsDataSourceUri :

from qgis.utils import iface

layer = iface.activeLayer()
layer.dataProvider().uri().geometryColumn()

Edit, after reading comments. It doesn't work for GPKG.

Answer 2

Use this:

from qgis.utils import iface
from qgis.core import QgsMapLayerUtils

v_layer = iface.activeLayer()

conn = QgsMapLayerUtils.databaseConnection(v_layer)
true_layer_name = v_layer.source().split('layername=')[-1]
table = conn.table('', true_layer_name)

print(table.geometryColumn())

Answer 3

Couldn't find a dataProvider property either, that shows the geometry column.

As a temporary hack, I would use GDAL OGR:

from osgeo import ogr
from qgis.utils import iface

layer = iface.activeLayer()
source = layer.source().split('|')
gpkg = source[0]
lname = source[1].split('=')[1]

conn = ogr.Open(gpkg)
l = conn.GetLayerByName(lname)
geomName = l.GetGeometryColumn()
print(geomName)