postgresql-json和jsonb问题记录
目录
postgresql json和jsonb问题记录
jsonb会打乱原json属性顺序，但是支持索引
原json：
[{
"ITEM": "W(nm)",
"HZ1": 0,
"HZ2": 0
}, {
"ITEM": "OL(nm)",
"HZ1": 0,
"HZ2": 0
}, {
"ITEM": "OR(nm)",
"HZ1": 0,
"HZ2": 0
}
]CREATE TABLE mc.test (
id int8 GENERATED BY DEFAULT AS IDENTITY NOT NULL,
json_detail jsonb NOT NULL
);json类型保存数据库后：
[{“HZ1”: 0, “HZ2”: 0, “ITEM”: “W(nm)”}, {“HZ1”: 0, “HZ2”: 0, “ITEM”: “OL(nm)”}, {“HZ1”: 0, “HZ2”: 0, “ITEM”: “OR(nm)”}]
改成json类型后：
CREATE TABLE mc.test (
id int8 GENERATED BY DEFAULT AS IDENTITY NOT NULL,
json_detail json NOT NULL
);[{“ITEM”:“W(nm)”,“HZ1”:0,“HZ2”:0},{“ITEM”:“OL(nm)”,“HZ1”:0,“HZ2”:0},{“ITEM”:“OR(nm)”,“HZ1”:0,“HZ2”:0}]
