X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B60DA9FA226 for ; Wed, 3 May 2006 09:03:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 14028-05 for ; Wed, 3 May 2006 09:03:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from r1.mycybernet.net (r1.mycybernet.net [209.5.206.8]) by postgresql.org (Postfix) with ESMTP id 1A3569F9C10 for ; Wed, 3 May 2006 09:03:00 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227]:49243 helo=phlogiston.dydns.org) by r1.mycybernet.net with esmtp (Exim 4.50 (FreeBSD)) id 1FbG4I-000MmS-SO for pgsql-sql@postgresql.org; Wed, 03 May 2006 08:02:59 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 292004040; Wed, 3 May 2006 08:02:58 -0400 (EDT) Date: Wed, 3 May 2006 08:02:58 -0400 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: i am getting error when i am using copy command Message-ID: <20060503120258.GC18836@phlogiston.dyndns.org> References: <4458639D.90806@logix-tt.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4458639D.90806@logix-tt.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/38 X-Sequence-Number: 25069 On Wed, May 03, 2006 at 10:02:37AM +0200, Markus Schaber wrote: > > file ?/tmp/penchal.out? for writing: no such file or directory.. > > It seems that the /tmp directory is missing from your system. Right. And notice that the "your system" here is the _server_, not the machine you're running psql from. If you want local files, you need to use \copy instead. A -- Andrew Sullivan | ajs@crankycanuck.ca It is above all style through which power defers to reason. --J. Robert Oppenheimer