| 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: | Raw Message | Whole Thread | 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
| 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 |