> Michael Fuhr <mike(at)fuhr(dot)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
99main Internet Services http://www.99main.com
In response to
pgsql-novice by date
|Next:||From: Kumar S||Date: 2004-10-15 21:15:45|
|Subject: syntax error at or near "Hs" at character 1182|
|Previous:||From: Tom Lane||Date: 2004-10-15 14:55:48|
|Subject: Re: copy error |