Re: Using COPY - Mailing list pgsql-general

From tony
Subject Re: Using COPY
Date
Msg-id 1021386613.1617.94.camel@vaio
Whole thread Raw
In response to Using COPY  (Joseph Koenig <joe@jwebmedia.com>)
List pgsql-general
On Tue, 2002-05-14 at 16:15, Joseph Koenig wrote:
> We're converting a db from Access to PostgreSQL for a client - I need to
> export all of his data into postgres on Linux - I'm trying to use the
> COPY command, however, his comment fields have line breaks in them which
> causes the copy to throw a parse error at that line. I'm sure others
> have run into this - is there an easy way to avoid this? Thanks,

Welcome to pain! Now when someone asks me to port data, I bill each and
every hour spent - no more estimates on how much it will cost!!!

I'm sure someone will recommend a perl script to rip them out.

If you aren't a perl guru then run out and find a Mac with BBEdit which
is the absolute best text editor in the world. A combination of BBEdit
and OpenOffice will clean up and format any text file and save it to
many types of text including CSV.

Cheers

Tony Grant
--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html


pgsql-general by date:

Previous
From: "Bertin, Philippe"
Date:
Subject: Re: Using COPY
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Question about setval() function