Postgres ad nested json

Question

I am trying to parse a field from a nested JSON using postgresql. The form of a JSON has the following form:

{"Field_1": {"Field_2": {"Field_3": "value_1": "xxx"}}}

I have read the question How do I query using fields inside the new PostgreSQL JSON datatype? and I have searched the proposed links, but I have not found anything to work.

{"Field_1": {"Field_2": {"Field_3": "value_1": "xxx"}}}

I want to parse the xxx of value_1.

score 1 · Answer 1 · answered Jun 14 '19 at 13:38

Your JSON have incorrect syntax, this is correct one:

{"Field_1": {"Field_2": {"Field_3": {"value_1": "xxx"}}}}

Then you can:

select j->'Field_1'->'Field_2'->'Field_3'->'value_1' from (
    select '{"Field_1": {"Field_2": {"Field_3": {"value_1": "xxx"}}}}'::jsonb as j
) t

1 Answers1