Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0C4399FBB65 for ; Tue, 8 May 2007 01:22:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 72084-02 for ; Tue, 8 May 2007 01:22:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from rrmailscan3.safenetbox.biz (unknown [203.25.40.75]) by postgresql.org (Postfix) with ESMTP id CEAFC9FB788 for ; Tue, 8 May 2007 01:22:11 -0300 (ADT) Received: from rrmailscan3.safenetbox.biz (rrmailscan3.safenetbox.biz [127.0.0.1]) by rrmailscan3.safenetbox.biz (Postfix) with ESMTP id 854FD1D4846A; Tue, 8 May 2007 14:22:10 +1000 (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 249C21D48458; Tue, 8 May 2007 14:22:09 +1000 (EST) Message-ID: <463FFAE9.1040403@autoledgers.com.au> Date: Tue, 08 May 2007 12:22:01 +0800 From: Paul Lambert User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: Phillip Smith CC: pgsql-sql@postgresql.org Subject: Re: Query RE using COPY References: <003b01c79127$6b957ee0$9b0014ac@wbaus090> In-Reply-To: <003b01c79127$6b957ee0$9b0014ac@wbaus090> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/56 X-Sequence-Number: 28337 Phillip Smith wrote: > Can you modify the 'extract' and make the extra column "\n" which is the > null escape? > > That would be the only other option. > > Right now the software that does the extracts is developed by our applications developers, but I'll be taking that onto my side in the near future, just looking for a workaround until then. -- Paul Lambert Database Administrator AutoLedgers