pg 中字符串中有特殊字符的处理(比如换行符)
imos=# SELECT replace('he\no',E'\n','L');
replace
---------
he\no
(1 row)
imos=# SELECT replace('he
imos'# o','\n','L');
replace
---------
he +
o
(1 row)
imos=#
imos=# SELECT replace('he
o',E'\n','L');
replace
---------
heLo
(1 row)