CODEWITHSUNDEEP
jsonpostgresqljsonb
Goutham Nithyananda
Goutham Nithyananda

Reputation: 939

Postgres Jsonb Column how to maintain json object order of parameters

I Have a use case, where I generate a hash of a JSON object created in java initially and insert the hash and JSON object into the Postgres table as String and jsonb respectively.

I need to validate the JSON object saved initially in regular intervals, During that I fetch the JSON object from Postgres which is stored in jsonb and generate a hash out of it and compare it with the hash generated initially. Both are different now.

The reason is initially when data was inserted order of parameters was different in JSON Object at retrieval the order is different. Ending up generating 2 different hash for the same data.

Please suggest.

Upvotes: 0

Views: 1359

Answers (1)

Adrian Klaver
Adrian Klaver

Reputation: 19620

Use json type instead of jsonb per JSON:

Because the json type stores an exact copy of the input text, it will preserve semantically-insignificant white space between tokens, as well as the order of keys within JSON objects. Also, if a JSON object within the value contains the same key more than once, all the key/value pairs are kept. (The processing functions consider the last value as the operative one.) By contrast, jsonb does not preserve white space, does not preserve the order of object keys, and does not keep duplicate object keys. If duplicate keys are specified in the input, only the last value is kept.

Upvotes: 2

Related Questions