pg数据库替换指定ip 配菜单是部署机ip发生变化,记录一下处理方法,先根据源ip查询出主键id,在将源ip替换成目标ip update sys_menu set href = replace(href, '10.116.63.4', '10.116.58.23') where id in( select * from sys_menu where href like '%10.116.58.23%' )