[Qgis-user] save a join between attribute and table in gpkg?

[Richard Duivenvoorde]

Hi Simon,

Not sure if it can be done from withing QGIS, but using other database client tools that can handle sqlite/gpkg files, you can create views (based on your query of the join) your own into the db. IF that view has a geom column, QGIS show it as a geom layer for what I know...

I like 'dbeaver' a lot because it can handle all my dbases. But there are also sqlite-only editors (sqlite manger on Linux for example)..

Regards,

Richard Duivenvoorde

On 17-10-2025 12:06, Simon Dietmann via QGIS-User wrote:
> Dear list,
> 
> I am trying to export some feature classes inside a common gpkg that have attribute joins to a table that’s also stored in the same gpkg.  Afaics there is no possibility to store the information about the table join also inside the gpkg, is that correct?
> 
> Is there a way to store (and share) the joins except sharing a .qgz file?
> 
> Thanks for your advice,
> 
> Regards
> 
> Simon
> 
> i.A. Simon Dietmann
> Projektleiter | Geograph
> 
> PGNU Planungsgesellschaft Natur & Umwelt mbH
> Amtsgericht Frankfurt am Main, HRB 111938;
> Geschäftsführer: Dr. Benjamin Hill, Dorit Thurm, Sebastian Braun
> Hamburger Allee 45 +++ 60486 Frankfurt am Main
> Durchwahl: +49 69 952964-32 +++ Fax: +49 69 952964-99
> E-Mail: dietmann at pgnu.de +++ Web: www.pgnu.de <http://www.pgnu.de>
> 
>> Diese E-Mail könnte vertrauliche und/oder rechtlich geschützte Informationen enthalten. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail sind nicht gestattet.
>> This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
> 
> 
> _______________________________________________
> QGIS-User mailing list
> QGIS-User at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user