Re: COPY error

You might have an additional tab in one of the fields in that row?

Cheers,
Claudio


-----Original Message-----
From: Nupur Pande
To: pgsql-cygwin@postgresql.org
Sent: 10/31/03 3:37 AM
Subject: [CYGWIN] COPY error

Hi,
I'm trying to copy data from an excel file into a postgres table. I
saved
the file in .txt format (tab delimited) from Excel (running on Windows
XP
machine) and then ran the d2u utility on the .txt file to convert it
into
unix format on cygwin. The command I executed was COPY [table_name] from
[full path of file name].
I get the following error message:
ERROR:  copy: line 1520, Extra data after last expected column
ERROR:  copy: line 1520, Extra data after last expected column

Could someone please tell me what I did wrong? I checked the excel table
and
I can't see any extra information on that line.

Thanks a lot..
Nupur


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

---
WE HAVE MOVED - PLEASE NOTE OUR NEW CONTACT DETAILS:
THE BASEMENT, 33 EWELL STREET, BALMAIN NSW 2041
TEL: +61 2 9555 1544 FAX: +61 2 9555 6911
Certain disclaimers and policies apply to all email sent from Memetrics.
For the full text of these disclaimers and policies see
http://www.memetrics.com/emailpolicy.html