the order is changed as well on your screenshot čt 22. 11. 2018 v 16:23 odesílatel Станислав Губанов <gubano...@gmail.com> napsal:
> I think yes. > Please look at this screen shot > order of key in json not changed in pgAdmin, maybe exists some option for > turn on/off this feature. > > [image: image.png] > > чт, 22 нояб. 2018 г. в 18:04, Josef Šimánek <josef.sima...@gmail.com>: > >> If I understand well your question, this is expected with JSONB. >> >> see https://www.postgresql.org/docs/current/datatype-json.html for more >> info: >> >> ...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... >> >> čt 22. 11. 2018 v 15:59 odesílatel Станислав Губанов <gubano...@gmail.com> >> napsal: >> >>> Hello! >>> >>> I'd like to clarify, if this a bug or a feature >>> >>> simple JSON >>> {"rootC":{},"rootB":{},"rootZ":{},"rootA":[]} >>> >>> Table for data >>> create table test_json (json_data jsonb); >>> >>> put json into table >>> INSERT INTO test_json (json_data) VALUES >>> ('{"rootC":{},"rootB":{},"rootZ":{},"rootA":[]}'); >>> >>> order of key in json is changed in such query: >>> SELECT json_data FROM test_json; >>> expected result: {"rootC":{},"rootB":{},"rootZ":{},"rootA":[]} >>> actual result: {"rootA": [], "rootB": {}, "rootC": {}, "rootZ": {}} >>> >>> ----- console log ----- >>> test=# create table test_json (json_data jsonb); >>> CREATE TABLE >>> test=# INSERT INTO test_json (json_data) VALUES >>> ('{"rootC":{},"rootB":{},"rootZ":{},"rootA":[]}'); >>> INSERT 0 1 >>> test=# select json_data from test_json; >>> json_data >>> ------------------------------------------------------ >>> {"rootA": [], "rootB": {}, "rootC": {}, "rootZ": {}} >>> (1 row) >>> >>> test=# drop table test_json; >>> DROP TABLE >>> >>> -- >>> Sincerely, Stanislav! >>> >> > > -- > С уважением, Станислав! >
