json data save into postgresql become different order

Question

When I save data into table , then do select from table it become different order, I check in pgadmin it is too.
Why?? and how to solve it?

CREATE TABLE IF NOT EXISTS "user_role_track"(
    "id" SERIAL NOT NULL,
    "create_date" timestamp without time zone,
    "create_by_user_id" integer,
    "action" integer,
    "old_data" jsonb,
    "new_data" jsonb
  );

data create in nodejs app

var newData = {
  "id": userRoleId,
  "create_date": timestamp,
  "user_id": userId,
  "role": role
};
... 

// save with promise sync function
var dbQueryR = yield Promise.resolve( queryPromise(dbClient, dbQuery, dbParams) );

select from table/ see through pgadmin

"{"id": 2, "role": 1, "user_id": 17, "create_date": "2016-07-11 09:09:18"}"

there is no guarantee in the order of the data stored due to the optimisations made by the DBMS. If u need a particular order, you should use ORDER BY to fetch the result. — mauris
– mauris, Commented Jul 11, 2016 at 1:19
If you are care about the order of the keys then use json instead of jsonb type. — Abelisto
– Abelisto, Commented Jul 11, 2016 at 3:17

Community · Accepted Answer · 2017-05-23 11:58:56Z

3

If I understand you rigtht, your json elements are mixed up after insert?..

then look at json specs

An object is an unordered set of name/value pairs

as stated in JSON order mixed up

You cannot and should not rely on the ordering of elements within a JSON object.

edited May 23, 2017 at 11:58

CommunityBot

11 silver badge

answered Jul 11, 2016 at 6:00

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

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

Collectives™ on Stack Overflow

json data save into postgresql become different order

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related