Home > Net >  PGSQL query to get all records of a column containing line breaks
PGSQL query to get all records of a column containing line breaks

Time:05-07

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

CodePudding user response:

You can try something like this

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