Re: import CSV file

From: T E Schmitz <mailreg(at)numerixtechnology(dot)de>
To: Jure Kodzoman <jure(at)plsavez(dot)hr>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: import CSV file
Date: 2007-03-13 23:48:43
Message-ID: 45F7385B.7090901@numerixtechnology.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jure Kodzoman wrote:
> 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
>

The problem was indeed that COPY was expecting the file on the server.

--

Regards,

Tarlika Elisabeth Schmitz

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message T E Schmitz 2007-03-13 23:52:17 Re: import CSV file
Previous Message T E Schmitz 2007-03-13 23:44:02 Re: import CSV file