How to find newline character in PostgreSQL

Vaing Muny
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

--

--

No responses yet