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