Re: Using COPY - Mailing list pgsql-novice

From Tomka Gergely
Subject Re: Using COPY
Date
Msg-id Pine.LNX.4.33.0309030829330.31338-100000@zeus.gau.hu
Whole thread Raw
In response to Re: Using COPY  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
2003-09-02 ragyogó napján Tom Lane ezt üzente:

> Juan Francisco Diaz <j-diaz@publicar.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..."


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: setting next value of an established sequence
Next
From: Oliver Fromme
Date:
Subject: Revoke access on pg_user