Re: Carraige Return issues

On Thu, 2002-07-04 at 16:15, caroline kenny wrote:

> I hope that someone outthere can help me. I am trying to insert the text
> from a file into a database. The file contains 2 carraige returns in it.
> When i go to retrieve this this information from the specific field in the
> database, the carraige return seems to have disappeared and the lines just
> read one after the other...does anyone know how i can overcome this problem

You need to escape the newline characters.

Here's an example of copying multiline text from a file

junk-# \! cat /tmp/ol
1 line 1 of text\
\
\
line4 of text
\.

junk=# copy tt from '/tmp/ol';
COPY
junk=# select * from tt;
id | t
----+--------------------------------
1 | line 1 of text


line4 of text
(1 row)

Oliver Elphick