postgresql remove new line from string

Impossible Iguana answered on January 26, 2021 Popularity 6/10 Helpfulness 6/10

answer postgresql remove new line from string

Comment

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

Popularity 6/10 Helpfulness 6/10 Language sql

Tags: line postgresql sql string

Link to this answer
Share Copy Link

Contributed on Jan 26 2021

Impossible Iguana

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.