Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 4081E9FB41C for ; Sun, 11 Feb 2007 19:28:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 92242-09 for ; Sun, 11 Feb 2007 19:28:52 -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 E584D9FB24E for ; Sun, 11 Feb 2007 19:28:55 -0400 (AST) Received: from rrmailscan3.safenetbox.biz (rrmailscan3.safenetbox.biz [127.0.0.1]) by rrmailscan3.safenetbox.biz (Postfix) with ESMTP id 4DC231D48432; Mon, 12 Feb 2007 10:29:09 +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 2C23B1D48424; Mon, 12 Feb 2007 10:29:08 +1100 (EST) Message-ID: <45CFA679.7080404@autoledgers.com.au> Date: Mon, 12 Feb 2007 08:27:53 +0900 From: Paul Lambert User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: Paul Lambert CC: pgsql-sql@postgresql.org Subject: Re: COPY FROM query. References: <45CFA478.5020505@autoledgers.com.au> In-Reply-To: <45CFA478.5020505@autoledgers.com.au> 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/131 X-Sequence-Number: 27465 An INSERT INTO will fix my problem with needing the extra copy from and copy to. I'm still curious as to why i was being told I couldn't specify a relative path though. P. -- Paul Lambert Database Administrator AutoLedgers