Re: Inserting CR/LF in a select? - Mailing list pgsql-general

Of course it will.... Thanks... :)

BTJ

On Fri, 2003-08-22 at 19:47, David Olbersen wrote:
> Bjørn T Johansen muttered:
>
> > I need to get two fields from two tables and append them into one field
> > with CR/LF in between, how is this done using a select?
>
> I believe something along the lines of:
>
>   SELECT column1||'\r\n'||column1 FROM table;
>
> will do the trick.