PostgreSQL : 如何將 JSON 資料匯入 TABLE ROW

JavaScript : Tour of heroes using AngularJS 1.x

PostgreSQL : 試試 JSON 函數

insert into members (name, gender, blood, age)
select j1.key "name", j1.value "gender", j2.value "blood", j3.value "age"
from json_each_text('{"Chris":"Male", "Kelly":"Female"}') as j1
join json_each_text('{"Chris":"A", "Kelly":"O"}') as j2 on j2.key = j1.key
join json_each_text('{"Chris":"42", "Kelly":"34"}') as j3 on j3.key = j1.key

"Chris";"Male";"A";"42"
"Kelly";"Female";"O";"34"

JSON Functions and Operators