[Qgis-user] Geopagkage and "geom" in DBmanager

[Lene Fischer]

Hi,
Trying out a geopackage layer in DBManager asking a simple SQL statement st_area
But when I try to write a statement like this

SELECT "vandopland".* , st_area("vandopland"."geom") as areal_m2
FROM "vandopland"

 "geom" is not found. Suggestions as geomfromexifgpsblob or geomfromfgf or geomfromwkb . Then I get "an error occured"

Any suggestions what I might have done wrong.

Regards from a newbee Geopagkace/DBmanager

Lene Fischer


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180913/a4296992/attachment.html>