Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 13A8A9FB309 for ; Tue, 13 Mar 2007 20:39:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 06779-09 for ; Tue, 13 Mar 2007 20:39:56 -0300 (ADT) X-Greylist: delayed 01:03:58.869904 by SQLgrey-1.7.4 Received: from fyodor.hcoop.net (fyodor.hcoop.net [64.20.38.170]) by postgresql.org (Postfix) with ESMTP id 3BF8C9FB270 for ; Tue, 13 Mar 2007 20:39:56 -0300 (ADT) Received: from dhcp-212-235-229-194.sd.uni-lj.si ([212.235.229.194]) by fyodor.hcoop.net with esmtpa (Exim 4.63) (envelope-from ) id 1HRFaz-0004B5-I8; Tue, 13 Mar 2007 18:35:56 -0400 Subject: Re: import CSV file From: Jure Kodzoman To: mailreg@numerixtechnology.de Cc: pgsql-sql@postgresql.org In-Reply-To: <45F70BC9.801@numerixtechnology.de> References: <45F70BC9.801@numerixtechnology.de> Content-Type: text/plain Date: Tue, 13 Mar 2007 23:35:51 +0100 Message-Id: <1173825351.5564.2.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.6.3 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/185 X-Sequence-Number: 27823 On Tue, 2007-03-13 at 20:38 +0000, T E Schmitz 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? > Try setting the permissions chmod a+r /tmp/FTSE.csv Best regards, Jure Kodzoman