'PGSQL query to get all records of a column containing line breaks

What is the shortest Pgsql query to get all records that contain a line-break in a given column ?

sql postgresql

Solution 1:^[1]

You can try something like this

select * from table_name where column_name ~ '\n';

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	Shankar