PGSQL String字符串转jsonb

-- users data是jsonb的数据 wechatuser data 是text
INSERT INTO users (data)  SELECT data wechatuser;
-- text 转 jsonb 无法兼容 修复
UPDATE users set  data = '{}'::jsonb where "data" = '""';
update users 
    set data = 
        jsonb(regexp_replace(regexp_replace(regexp_replace(data::text, '"$', ''),  '^"+', ''), '\\"', '"', 'g'));
           

问题来源：

https://stackoverflow.com/questions/48301317/postgres-query-to-convert-stringifyed-json-object-to-jsonb-object