| 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: | Whole Thread | Raw Message | 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? |