| From: | "Keith Worthington" <keithw(at)narrowpathinc(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Fuhr <mike(at)fuhr(dot)org> |
| Cc: | PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: copy error |
| Date: | 2004-10-15 15:07:50 |
| Message-ID: | 20041015150750.M39520@narrowpathinc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
> 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
the help.
Kind Regards,
Keith
______________________________________________
99main Internet Services http://www.99main.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kumar S | 2004-10-15 21:15:45 | syntax error at or near "Hs" at character 1182 |
| Previous Message | Tom Lane | 2004-10-15 14:55:48 | Re: copy error |