Using COPY

From: Joseph Koenig <joe(at)jwebmedia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Using COPY
Date: 2002-05-14 14:15:05
Message-ID: 3CE11BE9.B0CA9AD8@jwebmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-05-14 14:16:34 Re: Use of OIDS as primary keys
Previous Message Martijn van Oosterhout 2002-05-14 14:05:22 Re: transitioning postgres oid