Can't get a simple COPY to work

Поиск

Список

Период

Сортировка

От	runner
Тема	Can't get a simple COPY to work
Дата	16 марта 2011 г. 18:36:52
Msg-id	8CDB2395637DDAF-1380-CD7F@web-mmc-d05.sysops.aol.com обсуждение
Ответы	Fwd: Can't get a simple COPY to work Re: Can't get a simple COPY to work
Список	pgsql-general

Дерево обсуждения

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?

В списке pgsql-general по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Can't get a simple COPY to work