Feature request #3989

PostgreSQL hstore support

Added by pablotcarreira - almost 13 years ago. Updated almost 9 years ago.

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.

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

History

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

  • Target version changed from Version 1.7.0 to Version 1.7.4

#3 Updated by Giovanni Manghi about 12 years ago

  • Target version changed from Version 1.7.4 to Version 2.0.0

#4 Updated by Pirmin Kalberer over 11 years ago

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

#6 Updated by Giovanni Manghi about 11 years ago

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

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

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

#9 Updated by baditaflorin - almost 9 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 9 years ago

i am using the latest version of QGIS

Also available in: Atom PDF