Re: Inserting CR/LF in a select?

From: Bjørn T Johansen <btj(at)havleik(dot)no>
To: David Olbersen <DOlbersen(at)stbernard(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Inserting CR/LF in a select?
Date: 2003-08-22 18:32:01
Message-ID: 1061577121.20919.52.camel@pennywise.havleik.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Denis Komninakis Diniz 2003-08-22 19:35:32 difficulties in extracting data type.
Previous Message Hervé Piedvache 2003-08-22 18:30:28 WAL Files checkpoint_timeout with voluminous delete/insert