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';
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';