From: | Klaudia Walter <kw243(at)cam(dot)ac(dot)uk> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Problems with \copy |
Date: | 2002-04-25 13:39:39 |
Message-ID: | E4300C12-5851-11D6-B921-003065480ED4@cam.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Dear all,
I am having problems loading files with \copy. It seems that there are
problems with the newline character. I am working on Mac OS X 10.1.2.
and I am trying to load a file into postgresql that has been saved as a
tab delimited text file using excel. I tried already reading the file
via a Java program and writing it into a new file in order to be able to
write \n, \r and System.getProperty("line.separator") at the end of each
line. However, the error message is still
CopyReadNewline: extra fields ignored
Any suggestions?
Many thanks,
Klaudia
------------------------------------------
Klaudia Walter
Department of Pathology
University of Cambridge
Tennis Court Road
Cambridge CB2 1QP
Tel: 01223 333 338
email: kw243(at)cam(dot)ac(dot)uk
------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Duncan Adams (DNS) | 2002-04-25 15:00:42 | copy |
Previous Message | Henshall, Stuart - WCP | 2002-04-25 08:45:54 | Re: support for atomic multi-table updates? |