pgsql删除字段中的換行符

SELECT

 replace(replace(name,chr(13),''),chr(10),'') AS name 

FROM ml_meta_program where id = 33138 ;