Re: Issue with copying data from a text file.

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Issue with copying data from a text file.
Date: 2007-03-20 03:17:00
Message-ID: 20070320031659.GA23548@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Mar 20, 2007 at 11:25:38AM +0900, Paul Lambert wrote:
> I note an option in the COPY command to specify the quote character,
> defaulting to double quote. The problem being a single quote will also
> be used in the data, as will other characters. Is there any way to get a
> copy to have no quote character?

Are there any control characters that won't appear in the data?

--
Michael Fuhr

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Paul Lambert 2007-03-20 03:21:45 Re: Issue with copying data from a text file.
Previous Message Phillip Smith 2007-03-20 03:05:24 Re: Issue with copying data from a text file.