On Mon, 9 Sep 2002 [EMAIL PROTECTED] wrote:

> Long Description
> When I attempt to populate an empty table using copy from (specificaly
> while using a comma as the delimiter) I recieve an atoi error on the
> first row and the copy fails. If I add a comma to the end of the first
> row, I get a warning message about extra fields being ignored and the
> copy completes successfuly.
>
> The file I am using to copy from is generated by an oracle application
> that is saved onto a windows desktop and ftp'd to the linux machine
> running PostgreSQL.

Are you perhaps running into an end of line difference problem?  You
probably are getting CRLF vs LF.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to