Skip to content
Advertisement

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 ?

Advertisement

Answer

You can try something like this

select * from table_name where column_name ~ 'n';
User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement