Problems with \copy
От | Klaudia Walter |
---|---|
Тема | Problems with \copy |
Дата | |
Msg-id | E4300C12-5851-11D6-B921-003065480ED4@cam.ac.uk обсуждение исходный текст |
Ответы |
Re: Problems with \copy
|
Список | 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@cam.ac.uk ------------------------------------------
В списке pgsql-novice по дате отправления: