Feature request #18431

Option to add non-spatial attribute table from plain SQLite database

Added by Arjan Mossel about 6 years ago.

Status:Open
Priority:Normal
Assignee:-
Category:Data Provider/OGR
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:26320

Description

The docs say "QGIS allows you to load spatial and non-spatial layers. This currently includes tables supported by OGR [...]".

I see that "OGR optionally supports spatial and non-spatial tables stored in SQLite 3.x database files." (http://www.gdal.org/drv_sqlite.html)

But it doesn't work for a plain SQLite database (trying to add it from the Database manager):

dbname='/path/to/database.sqlite' table="attribute_table" sql= is an invalid layer - not loaded

Layers in the SQLite database are also not displayed in the browser panel, although a spatial table listed in geometry_columns can succesfully be added.

Also available in: Atom PDF