Feature request #3989

PostgreSQL hstore support

Added by pablotcarreira - almost 10 years ago. Updated almost 6 years ago.

Category:Data Provider
Pull Request or Patch supplied:No Resolution:fixed/implemented
Easy fix?:No Copied to github as #:13980


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.

Capture.PNG (167 KB) baditaflorin -, 2015-07-06 05:34 AM


#1 Updated by Emil Tin over 9 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 9 years ago

  • Target version changed from Version 1.7.0 to Version 1.7.4

#3 Updated by Giovanni Manghi almost 9 years ago

  • Target version changed from Version 1.7.4 to Version 2.0.0

#4 Updated by Pirmin Kalberer over 8 years ago

  • Target version changed from Version 2.0.0 to Future Release - Nice to have

#6 Updated by Giovanni Manghi about 8 years ago

  • Status changed from Open to Feedback
  • Pull Request or Patch supplied set to No

#7 Updated by Alexandre Neto almost 7 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 almost 7 years ago

  • Status changed from Feedback to Closed
  • Resolution set to fixed/implemented

#9 Updated by baditaflorin - almost 6 years ago

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 - almost 6 years ago

i am using the latest version of QGIS

Also available in: Atom PDF