Get nested keys hstore postgres

Question

I'm trying to get the nested key's of the following 2 strings, saved as hstore in an postgresdb:

{"values"=>"{\"60\"=>[\"hallo\"], \"63\"=>[\"9\"], \"62\"=>[\"Nein\", \"Vielleicht\"], \"61\"=>[\"Ja\"]}", "comment"=>"[\"hmm\"]"}"},
{"values"=>"{\"60\"=>[\"test?\"], \"63\"=>[\"9\"], \"62\"=>[\"Ja\", \"Nein\"], \"61\"=>[\"Ja\"]}", "comment"=>"[\"kommentar23\"]"}"}

to be clear, how can I get all the keys/numbers in sql?

I tried the akeys function and get "values", thats fine, thats the first key, but I don't know how to get the nested keys? I tried with subqueries with no success.

any advice?

Thanks, Patrick

roman · Accepted Answer · 2013-08-28 05:54:15Z

2

I'd say your hstore looks more like twisted JSON. You can try to replace => with : and parse it, for example, with python json module or, if you're using 9.3, with native json methods.

Or you can get skeys, convert it to hstore again and get values.

answered Aug 28, 2013 at 5:54

roman

118k30 gold badges205 silver badges209 bronze badges

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

Collectives™ on Stack Overflow

Get nested keys hstore postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related