Re: CR/LF conversion (was: import error) - Mailing list pgsql-sql

From Achilleus Mantzios
Subject Re: CR/LF conversion (was: import error)
Date
Msg-id Pine.LNX.4.44.0301281619370.15457-100000@matrix.gatewaynet.com
Whole thread Raw
In response to Re: CR/LF conversion (was: import error)  (Oliver Vecernik <vecernik@aon.at>)
List pgsql-sql
On Tue, 28 Jan 2003, Oliver Vecernik wrote:

> Oliver Vecernik schrieb:
>
> > Hi all!
> >
> > I'm trying to import a text file from Suunto Dive Manager. I've got
> > following table structure:
>
> Arghh ...
>
> It's always the same problem with CR/LF conversions ...
>
> After changing it to just LFs, everthing worked like a charm. Is there
> an elegant way to handle this automatically?

If your dates were german in the first place, keep them german during the
copy, otherwise you will
have wrong dates.

>
> Oliver
>
> --
> VECERNIK Datenerfassungssysteme
> A-2560 Hernstein, Hofkogelgasse 17
> Tel.: +43 2633 47530, Fax: DW 50
> http://members.aon.at/vecernik
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill@matrix.gatewaynet.com       mantzios@softlab.ece.ntua.gr



pgsql-sql by date:

Previous
From: Oliver Vecernik
Date:
Subject: Re: CR/LF conversion (was: import error)
Next
From: Oliver Vecernik
Date:
Subject: CSV import