Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 07C1A9FB2DA
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 13 Mar 2007 19:27:46 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024)
	with ESMTP id 40426-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 13 Mar 2007 19:27:39 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from druid.net (druid.net [66.96.28.249])
	by postgresql.org (Postfix) with ESMTP id D45829FA38A
	for <pgsql-sql@postgresql.org>; Tue, 13 Mar 2007 19:27:42 -0300 (ADT)
Received: from dilbert.druid.net (H245.C18.B96.tor.eicat.ca [66.96.18.245])
	by druid.net (Postfix) with SMTP id B1FBDB59F;
	Tue, 13 Mar 2007 18:27:43 -0400 (EDT)
Date: Tue, 13 Mar 2007 18:27:40 -0400
From: "D'Arcy J.M. Cain" <darcy@druid.net>
To: mailreg@numerixtechnology.de
Cc: pgsql-sql@postgresql.org
Subject: Re: import CSV file
Message-Id: <20070313182740.ef40e742.darcy@druid.net>
In-Reply-To: <45F70BC9.801@numerixtechnology.de>
References: <45F70BC9.801@numerixtechnology.de>
X-Mailer: Sylpheed version 2.2.0 (GTK+ 2.8.12; i386-portbld-freebsd6.1)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.124 tagged_above=0 required=5 tests=AWL, BAYES_40,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200703/183
X-Sequence-Number: 27821

On Tue, 13 Mar 2007 20:38:33 +0000
T E Schmitz <mailreg@numerixtechnology.de> wrote:
> I am trying to batch-load a tab-separated CSV file:
> 
> psql -h lolek  -U tes -d stockmarket -c "copy history from 
> '/tmp/FTSE.csv' CSV";
> 
> ERROR:  could not open file "/tmp/FTSE.csv" for reading: No such file or 
> directory
> 
> The file exists. Do I need to escape the quotes?