> 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