Postgres Pro
Downloads
Home   >   mailing lists

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

From David Olbersen
Subject Re: Inserting CR/LF in a select?
Date
Msg-id E7E213858379814A9AE48CA6754F5ECB0D707F@mail01.stbernard.com
Whole thread Raw
In response to Inserting CR/LF in a select?  (Bjørn T Johansen <btj@havleik.no>)
Responses Re: Inserting CR/LF in a select?  (Bjørn T Johansen <btj@havleik.no>)
List pgsql-general
Tree view 
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.

--
David Olbersen
iGuard Engineer
St. Bernard Software
11415 West Bernardo Court
San Diego, CA 92127

pgsql-general by date:

Previous
From: Bjørn T Johansen
Date:
Subject: Inserting CR/LF in a select?
Next
From: Hervé Piedvache
Date:
Subject: WAL Files checkpoint_timeout with voluminous delete/insert