Skip site navigation (1) Skip section navigation (2)

import CSV file

From: T E Schmitz <mailreg(at)numerixtechnology(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: import CSV file
Date: 2007-03-13 20:38:33
Message-ID: 45F70BC9.801@numerixtechnology.de (view raw or flat)
Thread:
Lists: pgsql-sql
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

Responses

pgsql-sql by date

Next:From: Greg ToombsDate: 2007-03-13 20:43:15
Subject: Re: Maintence DB
Previous:From: Ezequias R. da RochaDate: 2007-03-13 20:13:45
Subject: Maintence DB

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group