How to store a python dict in Postgresql hstore

Question

I would like to store this kind of dict in hstore. Is it supported by hstore?

dict= {'fieldnames':['type', 'precision', 'width', 'data']}

If not, is there a way to flatten that structure to make it supported by hstore?

Nekresh · Accepted Answer · 2015-10-07 15:50:08Z

3

What you'd want to do is write a wrapper on the field that will stringify nested data on writes and the de-serialize that info when you read it back.

e.g. you want to store it like this:

{"fieldnames" : "['type', 'precision', 'width', 'data']"}

you can do it using json.dumps:

{"fieldnames" : json.dumps(['type', 'precision', 'width', 'data'])}

Nekresh

2,99825 silver badges28 bronze badges

answered Apr 29, 2013 at 15:54

mjallday

10.2k9 gold badges54 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Not really, I would like to know if I could use this kind of dict in hstore, so I could access 'type' or 'data' individually for a 'fieldname'

Maybe I would have to create four hstore column, like {'fieldname:'type'} | {'fieldname:'precision'} | {'fieldname:'width'} | {'fieldname:'data'}

you want to use the json data type if you want nested data. hstore only provides a flat data structure.

hstore can now store keys that contain arrays as values. it is a perfectly acceptable type for the question asked.