Re: import CSV file

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