I'm having the following issue with QGIS. Adding a sqlite text table (Layer > Add Vector Table) QGIS hides the primary key field (having name id
). I understand also QGIS uses this field as unique id, but I need to have it in the attribute view because all my links and joins use this field.
I'm not able actually to perform a join with my vector tables.
I can neither change the column names, nor create views.
[GIS] Primary key field hidden on attribute table added to QGIS
attribute-tableqgis
Best Answer
Although your question has already been answered in the comments. Why don't just add a new field to the attribute-table with the same name and select $id (or $rownum) as input in the field-calculator?
Something like this: