How to find newline character in PostgreSQL
Apr 20, 2021
Sometimes the data migrated from legacy system gone wrong with “newline” as in the case
lory espupu mucadaki medi dao
Lory esplusum dois atuns e um pudim
That often brought wrong format in the report
To find those records we could use REGEXP_REPLACE
Query output returns row that has new line