Feature request #3989

PostgreSQL hstore support

Added by pablotcarreira - almost 6 years ago. Updated over 1 year ago.

Status:Closed Start Date:06/15/2011
Priority:Low Due date:
Assigned to:- % Done:


Category:Data Provider
Target version:Future Release - Nice to have
Platform: Resolution:fixed/implemented
Platform version: Pull Request or Patch supplied:No
Status info: Tag:


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 (166.8 kB) baditaflorin -, 07/06/2015 05:34 am


Updated by Emil Tin over 5 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

Updated by Giovanni Manghi over 5 years ago

  • Target version changed from Version 1.7.0 to Version 1.7.4

Updated by Giovanni Manghi almost 5 years ago

  • Target version changed from Version 1.7.4 to Version 2.0.0

Updated by Pirmin Kalberer over 4 years ago

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

Updated by Giovanni Manghi about 4 years ago

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

Updated by Alexandre Neto almost 3 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.

Updated by Paolo Cavallini almost 3 years ago

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

Updated by baditaflorin - over 1 year 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.

Updated by baditaflorin - over 1 year ago

i am using the latest version of QGIS

Also available in: Atom