Feature request #3989
PostgreSQL hstore support
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Low | ||
| Assignee: | - | ||
| Category: | Data Provider | ||
| Pull Request or Patch supplied: | No | Resolution: | fixed/implemented |
| Easy fix?: | No | Copied to github as #: | 13980 |
Description
hstore column type allows postgresql tables to handle key/value data in a simple manner. At this moment Qgis doesn't shows hstore columns. It would be great to have access to hstore columns in Qgis.
History
#1
Updated by Emil Tin over 11 years ago
+1. This would definitely make QGIS more useful when working with OpenStreetMap data. For example, the osmosis tool stores tags in a hstore column when exporting to a PostGIS database.
About hstore: http://www.postgresql.org/docs/9.0/static/hstore.html
#2
Updated by Giovanni Manghi about 11 years ago
- Target version changed from Version 1.7.0 to Version 1.7.4
#3
Updated by Giovanni Manghi almost 11 years ago
- Target version changed from Version 1.7.4 to Version 2.0.0
#4
Updated by Pirmin Kalberer over 10 years ago
- Target version changed from Version 2.0.0 to Future Release - Nice to have
#5
Updated by Denis Rouzaud almost 10 years ago
Should be solved in 8176da04f28682b4a7ab4f396c91186ea8f614da
#6
Updated by Giovanni Manghi almost 10 years ago
- Status changed from Open to Feedback
- Pull Request or Patch supplied set to No
#7
Updated by Alexandre Neto over 8 years ago
This ticket should be closed.
The latest versions of QGIS show hstore fields as text, that can be edited and commited to Postgis DB.
#8
Updated by Paolo Cavallini over 8 years ago
- Status changed from Feedback to Closed
- Resolution set to fixed/implemented
#9
Updated by baditaflorin - over 7 years ago
- File Capture.PNG added
I load the osm.pbf file to a postgresql with osmosis , but then i cannot do nothing with the data, because all the tags are stored ina hstore that i was not albe to proces, and on the internet i did not find a method to split.
#10
Updated by baditaflorin - over 7 years ago
i am using the latest version of QGIS