How to do in SQL?

Question

I want to pair together two texts from two tables with the Enter character between them.

What I did so far is:

select text1 || '
' || text2
from A
join B u
using (id)

For example if: text1='Hello' and text2='World'

it will give:

Hello
World

the

|| '
    ' ||

gives the Enter key. Is there another way to do it something like ascii code or what ever? It feels stiuped to do it this way.

Note: This is PoostgreSql question. I initially tagged it this way. Answers from SQL SERVER does not apply here.

Flagging duplicate. http://stackoverflow.com/questions/31057/how-to-insert-a-line-break-in-a-sql-server-varchar-nvarchar-string — Deep Kalra, Feb 08 '16 at 11:53
Solution found: chr(10) from here: http://stackoverflow.com/questions/26638615/insert-line-break-in-postgresql-when-updating-text-field — java, Feb 08 '16 at 11:55

Marco · Accepted Answer · 2016-02-08T11:54:20.880

2

try \n:

select text1 || E'\n' || text2
from A
join B u
using (id)

edited Feb 08 '16 at 11:54

answered Feb 08 '16 at 11:52

Marco

It will print Hello\nWorld – java Feb 08 '16 at 11:53
1

Forgot the capital E for marking the escape string constant – Marco Feb 08 '16 at 11:56
What is the diffrance between that and chr(10)? – java Feb 08 '16 at 11:57
1

There is none, really. Both insert a line feed. chr(10) takes the 11 ASCII character (index 10), which is a Line feed. – Marco Feb 08 '16 at 12:04

1 Answers1