postgres 清除换行,回车,首尾空格
UPDATE res_partner set name = trim(name); --除空格
UPDATE res_partner set name = replace(name,chr(13),'')
update res_partner set name = replace(name,chr(10),'')
本文来自博客园,作者:那时一个人,转载请注明原文链接:https://www.cnblogs.com/qianxunman/p/12915710.html