Re: import CSV file

From: Jure Kodzoman <jure(at)plsavez(dot)hr>
To: mailreg(at)numerixtechnology(dot)de
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: import CSV file
Date: 2007-03-13 22:35:51
Message-ID: 1173825351.5564.2.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message T E Schmitz 2007-03-13 23:44:02 Re: import CSV file
Previous Message D'Arcy J.M. Cain 2007-03-13 22:27:40 Re: import CSV file