Re: copy notice
От | Oliver Elphick |
---|---|
Тема | Re: copy notice |
Дата | |
Msg-id | 1014325341.3217.810.camel@linda обсуждение исходный текст |
Ответ на | copy notice (muratmy@hotmail.com (my)) |
Список | pgsql-general |
On Thu, 2002-02-21 at 10:54, my wrote: > Hi , > I load a | delimited text file into a table using the following command : > copy table_name from '/usr/local/pgsql/table_name.dat' using delimiters '|'; > > and get this notice for each row : > > NOTICE: copy: line 21579, CopyReadNewline: extra fields ignored > > but the rows are loaded succesfully, why do I get this notice ? You have probably managed to escape the new line at the end of that particular line in the input file, so that it is tagging the first part of line 21580 onto the end of the last field. The rest of line 21580 gets thrown away. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "My sheep hear my voice, and I know them, and they follow me; And I give unto them eternal life; and they shall never perish, neither shall any man pluck them out of my hand." John 10:27,28
В списке pgsql-general по дате отправления: