import CSV file

From: T E Schmitz <mailreg(at)numerixtechnology(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: import CSV file
Date: 2007-03-13 20:38:33
Message-ID: 45F70BC9.801@numerixtechnology.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

set-up: Postgres 8.1, Debian
--

Best Regards,

Tarlika Elisabeth Schmitz

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Greg Toombs 2007-03-13 20:43:15 Re: Maintence DB
Previous Message Ezequias R. da Rocha 2007-03-13 20:13:45 Maintence DB