Re: import CSV file - Mailing list pgsql-sql

From Jure Kodzoman
Subject Re: import CSV file
Date
Msg-id 1173825351.5564.2.camel@localhost.localdomain
Whole thread Raw
In response to import CSV file  (T E Schmitz <mailreg@numerixtechnology.de>)
Responses Re: import CSV file
List pgsql-sql
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

Best regards,

Jure Kodzoman



pgsql-sql by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: import CSV file
Next
From: T E Schmitz
Date:
Subject: Re: import CSV file