我没能找到解决这个问题的办法.
假设我有一张这样的桌子
with tmp_table(json_row, message) as (
values
('{"key1": 1, "key2":"first"}'::jsonb, 'this ${key2} is a test of ${key1}'),
('{"key1": 2, "key2":"second"}', 'this ${key2} is a test'),
('{"key1": 3, "key2":"third"}', 'this ${key1} is a test of ${key2}')
)
select * from tmp_table
如何从另一列的json值替换外部参数,以便预期的结果是
提前谢谢!
编辑:我希望这是与正则表达式-替换,以寻找之间的${}