Re: carriage returns out as \n

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Anne Wainwright <anotheranne(at)fables(dot)co(dot)za>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: carriage returns out as \n
Date: 2013-07-11 19:07:33
Message-ID: 27830.1373569653@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Anne Wainwright <anotheranne(at)fables(dot)co(dot)za> writes:
> Data input includes carriage returns.
> When I extract query results in delimited format these have been
> replaced by '\n'

No such transformation is done within the database proper. I suppose
that something on the client side is doing that for/to you, but since
you've provided no details about what you're doing, it's hard to guess
exactly where it's happening.

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Anne Wainwright 2013-07-12 07:00:10 Re: carriage returns out as \n
Previous Message Anne Wainwright 2013-07-11 18:35:49 carriage returns out as \n