Postgres Pro
Downloads
Home   >   mailing lists

import CSV file - Mailing list pgsql-sql

From T E Schmitz
Subject import CSV file
Date
Msg-id 45F70BC9.801@numerixtechnology.de
Whole thread Raw
Responses Re: import CSV file  ("D'Arcy J.M. Cain" <darcy@druid.net>)
Re: import CSV file  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: import CSV file  (Jure Kodzoman <jure@plsavez.hr>)
List pgsql-sql
Tree view 
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?


set-up: Postgres 8.1, Debian
-- 


Best Regards,

Tarlika Elisabeth Schmitz

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgres configuration
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: import CSV file