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