Re: using cr/lf files in copy from

From: John McKown <joarmc(at)swbell(dot)net>
To: "Sergio A(dot) Kessler" <sak(at)tribctas(dot)gba(dot)gov(dot)ar>
Cc: pgsql-general(at)hub(dot)org
Subject: Re: using cr/lf files in copy from
Date: 2000-10-13 18:41:58
Message-ID: Pine.LNX.4.21.0010131338300.21642-100000@linux2.johnmckown.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vilson farias 2000-10-13 18:53:25 Question about pg_dump
Previous Message Stephan Szabo 2000-10-13 18:41:08 Re: Postgres-7.0.2 optimization question