postgresql 字符串变json 再还原
时间：2021-07-01 10:21:17
帮助过：145人阅读
*
from json_to_record(
‘{"a":1,"b":[1,2,3],"c":"bar"}‘)
as x(a
int, b INTEGER[], c text)
SELECT row_to_json(
a.*
) from (
select *
from json_to_record(
‘{"a":1,"b":[1,2,3],"c":"bar"}‘)
as x(a
int, b INTEGER[], c text)) a
postgresql 字符串变json 再还原
标签：integer color div rom text http 字符 record gre
