Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2F9399FB31D for ; Sun, 11 Feb 2007 20:52:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 72110-03 for ; Sun, 11 Feb 2007 20:52:46 -0400 (AST) 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 3CE7E9FB2CB for ; Sun, 11 Feb 2007 20:52:46 -0400 (AST) Received: from rrmailscan3.safenetbox.biz (rrmailscan3.safenetbox.biz [127.0.0.1]) by rrmailscan3.safenetbox.biz (Postfix) with ESMTP id 9BDF51D4846F; Mon, 12 Feb 2007 11:52:59 +1100 (EST) Received: from [172.17.2.14] (online4-new.lnk.telstra.net [139.130.169.227]) (Authenticated sender: remote) by rrmailscan3.safenetbox.biz (Postfix) with ESMTP id A1FA41D4843B; Mon, 12 Feb 2007 11:52:58 +1100 (EST) Message-ID: <45CFBA1F.9090109@autoledgers.com.au> Date: Mon, 12 Feb 2007 09:51:43 +0900 From: Paul Lambert User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: Phillip Smith CC: 'Joe' , pgsql-sql@postgresql.org Subject: Re: COPY FROM query. References: <00d601c74e3f$5fc59940$9b0014ac@wbaus090> In-Reply-To: <00d601c74e3f$5fc59940$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-Spam-Status: No, hits=0.12 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200702/135 X-Sequence-Number: 27469 Phillip Smith wrote: > "Having said that, if I switch it to a forward slash it works without > error... odd, given that weenblows standard is backslash." > > Yes, but PostgreSQL uses a back-slash as an escape character, which needs to > be used to escape itself at an application level before the O/S gets to deal > with it :) > > -p > > OK, that makes sense, cheers for the help. -- Paul Lambert Database Administrator AutoLedgers