Обсуждение: carriage returns out as \n

Hello,

Data input includes carriage returns.

When I extract query results in delimited format these have been
replaced by '\n'

Currently I run a perl script to replace the '\n' by a cr as needed by
the final application

Is there an alternative for this where postgres will output or store
the original cr?

many thanks
Anne

Anne Wainwright <anotheranne@fables.co.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

Thank you Tom.

I have issues with " which I know is an issue with the clientside of
things so am sure this is then the same.

regards
Anne

On Thu, Jul 11, 2013 at 03:07:33PM -0400, Tom Lane wrote:
> Anne Wainwright <anotheranne@fables.co.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