Skip site navigation (1) Skip section navigation (2)

Carriage return in text fields

From: "Ets ROLLAND" <ets(at)rolland-fr(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Carriage return in text fields
Date: 2005-05-30 08:19:10
Message-ID: 007601c564f0$bf141460$0a00a8c0@lrp43208 (view raw or flat)
Thread:
Lists: pgsql-general
Hello !

I have to transfert data from MS-Access to PostgreSQL 8.03 under Windows 2003 server.
Text fields may contain a carriage return (CR-LF).
I use the copy instruction.
Under Pg-Admin III 1.21, I obtain an error message for that carriage return and a hint : use \n.
If I use a filter on the cvs file replacing carriage return with \n, copy works but I have the char \n
in the text fields, not the carriage return !?
If I use PSQL, the carriage return are replaced by a space !
In Pg-Admin III I can insert a carriage return (with SHIFT ENTER) in a text field.

How can I transfert my text fields WITH all the carriage return inside the text fields ?
Thanks for your tips...
Best regards.

Luc

Responses

pgsql-general by date

Next:From: Zlatko MaticDate: 2005-05-30 09:15:27
Subject: Re: Audit trail ?
Previous:From: Karsten HilbertDate: 2005-05-29 19:22:39
Subject: Re: [Pypgsql-users] Timestamp with and without time zone...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group