Re: copy error

> Michael Fuhr <mike@fuhr.org> writes:
> > I'd guess that there's a carriage return at the end of line 1.
>
> Looks like that to me too.
>
> > You might need to run your data through a filter before importing
> > it into PostgreSQL.  Some systems have a dos2unix program; you could
> > also use tr, sed, perl, awk, etc. to strip trailing carriage returns.
>
> Alternatively, update to PG 7.4 or later.  Since 7.4 COPY will
> attempt to Do The Right Thing with files containing Windows-style newlines.
>
>             regards, tom lane

It turns out there was a carrige return at the end of every line.  Thasnk for
the help.

Kind Regards,
Keith

______________________________________________
99main Internet Services http://www.99main.com