Re: Can't get a simple COPY to work

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(dot)klaver(at)gmail(dot)com