Json property not coming in Order from Postgres

Question

i am trying to query like below,

OPT_VAR JSONB;
select 
json_build_object('CustomerProfile',t) into OPT_VAR 
from
(
select firstName,LastName,Type,Gender
from TABLE_NAME
)t;

My expected output like

{
    "CustomerProfile": {
        "firstName": "Sam",
        "LastName": "Smith",
        "Type": "A1",
        "Gender": "Male"
        }
}

But i am getting something like,

{
    "CustomerProfile": {
        "firstName": "Sam",
         "Gender": "Male",
        "LastName": "Smith",
        "Type": "A1"
        }
}

My only concern is order of the json property.

Filip Halaxa · Accepted Answer · 2021-07-07 11:51:48Z

2

The definition at json.org says:

An object is an unordered set of name/value pairs

So you should not depend on the order of keys in JSON. That's probably why Postgres does not care about the order in the JSON output.

answered Jul 7, 2021 at 11:51

Filip Halaxa

7786 silver badges14 bronze badges

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

Comments

A_Sk · Accepted Answer · 2021-07-07 12:57:35Z

0

in the comment as mentioned by a-horse-with-no-name

OPT_VAR JSON; instead of OPT_VAR JSONB;

answered Jul 7, 2021 at 12:57

A_Sk

4,6505 gold badges31 silver badges55 bronze badges