Обсуждение: Can't get a simple COPY to work

Поиск
Список
Период
Сортировка

Can't get a simple COPY to work

От
runner
Дата:

I'm getting really frustrated, I can't get a simple COPY command to work.  I've tried running psql and both the postgres user and the owner of the database with the same error.

psql -U postgres -d database1


database1=#  BEGIN;
BEGIN
database1=#  TRUNCATE TABLE grades;
TRUNCATE TABLE
database1=#  COPY grades FROM grades_csv_file;
ERROR:  syntax error at or near grades_csv_file


It won't let me enter the full path to the csv file and if I run psql from the directory where the csv file is located, it stilll won't accept the name of the csv file.    So how do you specify the name of the csv file?

Fwd: Can't get a simple COPY to work

От
runner
Дата:


> I'm getting really frustrated, I can't get a simple COPY
> command to work.  I've tried running psql and both the
> postgres user and the owner of the database with the same error.


Sorry about the, I see the file name requires a quote. 

Re: Can't get a simple COPY to work

От
Adrian Klaver
Дата:
On Wednesday, March 16, 2011 2:36:25 pm runner wrote:
>  I'm getting really frustrated, I can't get a simple COPY command to work.
> I've tried running psql and both the postgres user and the owner of the
> database with the same error.
>
> psql -U postgres -d database1
>
>
> database1=#  BEGIN;
> BEGIN
> database1=#  TRUNCATE TABLE grades;
> TRUNCATE TABLE
> database1=#  COPY grades FROM grades_csv_file;
> ERROR:  syntax error at or near grades_csv_file
>
>
> It won't let me enter the full path to the csv file and if I run psql from
> the directory where the csv file is located, it stilll won't accept the
> name of the csv file.    So how do you specify the name of the csv file?

COPY grades FROM 'grades_csv_file';
--
Adrian Klaver
adrian.klaver@gmail.com