| From: | Tomka Gergely <tomka(at)zeus(dot)gau(dot)hu> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Juan Francisco Diaz <j-diaz(at)publicar(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Using COPY |
| Date: | 2003-09-03 06:30:09 |
| Message-ID: | Pine.LNX.4.33.0309030829330.31338-100000@zeus.gau.hu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
2003-09-02 ragyogó napján Tom Lane ezt üzente:
> Juan Francisco Diaz <j-diaz(at)publicar(dot)com> writes:
> > The file was exported from mssqlserver2000 with ANSI coding, <cr> as row
> > separator, no quotes for the texts, and TAB as the column separator.
>
> Wrong thing :-(. COPY will *only* accept <lf> as row separators.
>
> This is relaxed for 7.4, but you're evidently not on 7.4 yet ...
tr '\r' '\n' < badfile > goodfile
--
Tomka Gergely
"S most - vajon barbárok nélkül mi lesz velünk?
Ők mégiscsak megoldás voltak valahogy..."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Fromme | 2003-09-03 08:58:36 | Revoke access on pg_user |
| Previous Message | Tom Lane | 2003-09-03 05:11:02 | Re: setting next value of an established sequence |