syntax error for copy command in postgresql

Question

I used the command:

COPY studentapp_deg_course_cat(degree_code, specialization, category_level1, category_level2, category_level3, min_credit, max_credit, primary)
FROM '/home/abhishek/Downloads/courses.csv'
USING DELIMITERS ';'

and i am getting the following error:

ERROR:  syntax error at or near "COPY" LINE 1: COPY studentapp_deg_course_cat(degree_code, specialization,...
        ^

********** Error **********

ERROR: syntax error at or near "COPY" SQL state: 42601 Character: 1

I would like to know the error in my code

Your version of Postgres? Your OS?

Erwin Brandstetter
– Erwin Brandstetter

2014-04-08 15:27:03 +00:00
Commented Apr 8, 2014 at 15:27 — Erwin Brandstetter
– Erwin Brandstetter, Commented Apr 8, 2014 at 15:27
i am using ubuntu 13.04 and postgres version is 9.1.11

Abhishek
– Abhishek

2014-04-08 15:29:24 +00:00
Commented Apr 8, 2014 at 15:29 — Abhishek
– Abhishek, Commented Apr 8, 2014 at 15:29

Erwin Brandstetter · Accepted Answer · 2014-04-08 16:18:23Z

1

Valid COPY syntax for version 9.1 on Linux should be:

COPY studentapp_deg_course_cat(degree_code, specialization, category_level1,
            category_level2, category_level3, min_credit, max_credit, "primary")
FROM '/home/abhishek/Downloads/courses.csv'
WITH (DELIMITER ';')

WITH, not ~~USING~~.
DELIMITER instead of ~~DELIMITERS~~.

And do not use primary as column name. It's a reserved word.

edited Apr 8, 2014 at 16:18

answered Apr 8, 2014 at 15:30

Erwin Brandstetter

669k160 gold badges1.2k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Abhishek Over a year ago

Hi i tried the command you gave and i am still getting the same error..There are a few blank spaces in the cells of the csv file. Might that be a reason?

Erwin Brandstetter Over a year ago

@AbhishekReddy: No, you get a syntax error. You never even get that far ... Found & fixed another one.

Collectives™ on Stack Overflow

syntax error for copy command in postgresql

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related