0

I am having below format JSON data, I want to load into PostgreSQL table with normalized into multiple tables.

I have gone through below link link description here

{
"Ref_1": "Value_1",
"Ref_2": "Value_2",
"Ref_7": {
    "Name_a": [
        {
            "Att1": "val_A1",
            "Att2": val_A2,
            "Att3": "val_A3"
        }
    ],
    "Name_e": [
        {
            "Att1": "val_E1",
            "Att2": {
                "Name_e_1": [
                    {
                        "Att_e_1": "val_E2",
                        "Att_e_2": val_E3,
                        "Att_e_3": "val_E4"
                    }
                ],
                "Name_e_2": [
                    {
                        "Att_e_1": "val_E8",
                        "Att_e_2": val_E9
                    }
                ],
                "Name_e_3": [
                    {
                        "Att_e_1": "val_E12",
                        "Att_e_2": val_E13
                    }
                ]
            },
            "Att3": val_E16,
            "Att4": "val_E17"
        }
    ],
"Ref_8": Value_7,
"Ref_9": Value_8

}

No Errors, I am looking for logic on implementation.

Improve this question
2
  • I have tried a few select statements, I am getting below error. ERROR: cannot extract elements from an object SQL state: 22023 Commented Sep 4, 2019 at 20:28
  • Please show what you tried. Commented Sep 5, 2019 at 7:18
Related questions
5
Populate multiple tables from a single JSON object with json_populate_recordset
3
Call to_json on multiple columns using Postgres
1
How to nest multiple postgreSQL tables into one json?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.