Re: new line in psotgres

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: new line in psotgres
Date: 2013-11-10 01:43:40
Message-ID: 527EE4CC.9050003@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/9/2013 5:33 PM, Gavin Flower wrote:
>
> I redid the above, and included at test with 'E' & '\n' - just one
> slash before the 'n'. The other changes are mostly cosmetic.

E'....\\n....' would be required if you were entering the string in a
programming language that itself used \ as an escape, as this way it
would pass a literal \ to postgres, which would use that to escape the n

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-11-10 04:49:55 Re: Odd behavior in functions w/ anyarray & anyelement
Previous Message Gavin Flower 2013-11-10 01:33:06 Re: new line in psotgres