postgresql remove line breaks code example

Example: postgresql remove new line from string

select regexp_replace(field, E'[\\n\\r\\f\\u000B\\u0085\\u2028\\u2029]+', ' ', 'g' )