carriage returns out as \n

From: Anne Wainwright <anotheranne(at)fables(dot)co(dot)za>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: carriage returns out as \n
Date: 2013-07-11 18:35:49
Message-ID: 20130711183549.GA25437@fables.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2013-07-11 19:07:33 Re: carriage returns out as \n
Previous Message Kevin Grittner 2013-07-10 15:49:08 Re: hstore for handling large amounts of events?