Feature request #18431
Option to add non-spatial attribute table from plain SQLite database
| 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.