postgresql 将jsonb中的数据替换为指定数据

UPDATE test_report_data
SET data = (
SELECT CAST(REPLACE(data::text, '139.196.154.85:10017', 'localhost') AS jsonb)
)

UPDATE test_report_data
SET data = (
SELECT CAST(REPLACE(data::text, 'localhost', '139.196.154.85:10017') AS jsonb)
)

替换字段中的值：

update dev_file
SET download_path = REPLACE(download_path, 'C:/NDForest/PM2Deployment', 'F:\AppWeb\guohe\PM2DeploymentLTS')