Using COPY - Mailing list pgsql-general

From Joseph Koenig
Subject Using COPY
Date
Msg-id 3CE11BE9.B0CA9AD8@jwebmedia.com
Whole thread Raw
Responses Re: Using COPY
Re: Using COPY
List pgsql-general
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,

Joe

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: transitioning postgres oid
Next
From: Tom Lane
Date:
Subject: Re: Use of OIDS as primary keys