Postgres Pro
Downloads
Home   >   mailing lists

Re: Issue with copying data from a text file. - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: Issue with copying data from a text file.
Date
Msg-id 20070320031659.GA23548@winnie.fuhr.org
Whole thread Raw
In response to Issue with copying data from a text file.  (Paul Lambert <paul.lambert@autoledgers.com.au>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Phillip Smith
Date:
Subject: Re: Issue with copying data from a text file.
Next
From: Paul Lambert
Date:
Subject: Re: Issue with copying data from a text file.