我有一个json,其中存储了一个数据数组。数据是基于键值存储的。我需要将我的数据解析为两列,其中键将在第一列,对应的值将在第二列。
使用PostgreSQL 15
select * from json_populate_recordset(null::json_parse_type, '[{"vartanyan":1},{"ermilova":2},{"dyakonov":2},{"sokornov":2},
{"shevchenko":2},{"kreslavskaya":2},{"vartanyan":2},{"jusupov":2},{"kamenkov":2},{"davidiuk":2},{"markhipova":2},
{"voronova":2},{"karamyshev":2},{"cheryabkin":2},{"sstepanov":2},{"shumeeva":2},{"balanda":2},{"mineev":2}]');
1条答案
按热度按时间yzuktlbb1#