How to include or remove enter, line break, new line of a string - Postgresql

Question

Navigation

#1 by (1 votes)

0

How to remove or include "line break", "enter", "new line" of a string result in postgres.

The result is:

comentário
Texto do comentário
Mais texto

And I want to:

comentário
Texto do comentário - Mais texto

Or the other way round

sql postgresql

asked by anonymous 16.10.2015 / 22:21

1 answer

Java cast and convert How do I get value in the td tag in jquery?

score 1 · Accepted Answer

To remove, we can use:

select regexp_replace(sua_coluna, E'[\n\r]+', ' - ', 'g' )

OR

select regexp_replace(sua_coluna, '[\n\r]+', ' - ', 'g' )

To include a new line use:

select E'Primeira Linha\nSegunda linha.'

OR

select E'Primeira Linha'||chr(10)||'Segunda linha.'

OR as @David

select E'Primeira Linha'||chr(13)||'Segunda linha.'

Sources: link

For more information, read the link