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
join B u
For example if:
it will give:
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.