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 almost 14 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 over 13 years ago
- Target version changed from Version 1.7.0 to Version 1.7.4
#3
Updated by Giovanni Manghi over 13 years ago
- Target version changed from Version 1.7.4 to Version 2.0.0
#4
Updated by Pirmin Kalberer almost 13 years ago
- Target version changed from Version 2.0.0 to Future Release - Nice to have
#5
Updated by Denis Rouzaud over 12 years ago
Should be solved in 8176da04f28682b4a7ab4f396c91186ea8f614da
#6
Updated by Giovanni Manghi over 12 years ago
- Status changed from Open to Feedback
- Pull Request or Patch supplied set to No
#7
Updated by Alexandre Neto about 11 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 about 11 years ago
- Status changed from Feedback to Closed
- Resolution set to fixed/implemented
#9
Updated by baditaflorin - about 10 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 - about 10 years ago
i am using the latest version of QGIS