Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 3C2DF9FB484 for ; Tue, 20 Mar 2007 00:22:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 42205-02 for ; Tue, 20 Mar 2007 00:22:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from rrmailscan3.safenetbox.biz (unknown [203.25.40.75]) by postgresql.org (Postfix) with ESMTP id 1051B9FB47B for ; Tue, 20 Mar 2007 00:22:16 -0300 (ADT) Received: from rrmailscan3.safenetbox.biz (rrmailscan3.safenetbox.biz [127.0.0.1]) by rrmailscan3.safenetbox.biz (Postfix) with ESMTP id 3BB771D48466 for ; Tue, 20 Mar 2007 14:22:14 +1100 (EST) Received: from [127.0.0.1] (online4-new.lnk.telstra.net [139.130.169.227]) (Authenticated sender: remote) by rrmailscan3.safenetbox.biz (Postfix) with ESMTP id 3BD601D4844D for ; Tue, 20 Mar 2007 14:22:13 +1100 (EST) Message-ID: <45FF5349.1020406@autoledgers.com.au> Date: Tue, 20 Mar 2007 12:21:45 +0900 From: Paul Lambert User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: Issue with copying data from a text file. References: <45FF4622.2010404@autoledgers.com.au> <1174358236.10466.14.camel@it-laptop> <45FF4AA3.4060808@autoledgers.com.au> <45FF4DFA.1020202@autoledgers.com.au> <1174359924.10466.32.camel@it-laptop> In-Reply-To: <1174359924.10466.32.camel@it-laptop> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/263 X-Sequence-Number: 27901 Phillip Smith wrote: > Maybe use char 254 or 253 or something similar... Anything that isn't > going to be found in the file. > > Have you tried using a string as a delimiter? QUOTE > 'THIS.STRING.ISNT.IN.THE.TEXT.FILE' > > ~p > I changed it to QUOTE '\f' to set the quote character to form-feed which is not going to appear in the file and that appears to do the trick without any changes to the source file. Thanks, P. -- Paul Lambert Database Administrator AutoLedgers