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: (view raw or whole 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 

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

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-2015 The PostgreSQL Global Development Group