Re: using cr/lf files in copy from - Mailing list pgsql-general

From John McKown
Subject Re: using cr/lf files in copy from
Date
Msg-id Pine.LNX.4.21.0010131338300.21642-100000@linux2.johnmckown.net
Whole thread Raw
In response to using cr/lf files in copy from  ("Sergio A. Kessler" <sak@tribctas.gba.gov.ar>)
List pgsql-general
Correct. I've always had to convert from DOS style to UNIX style lines. I
have a program called DOS2UNIX which does that. You can also use sed

sed 's/\r$//' <dos.style >unix.style


On Fri, 13 Oct 2000, Sergio A. Kessler wrote:

>
> it's just me or COPY FROM doesn't cope with DOS style lines ? (ie cr/lf)
>


pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: Postgres-7.0.2 optimization question
Next
From: Stephan Szabo
Date:
Subject: Re: Postgres-7.0.2 optimization question