Postgres 9 \COPY FROM Command - Reserved Keyword

Question

I am having an issue trying to run \copy command where my column name is desc

I've tried the following:

psql -U user -p 1234 -h hostname -c "\copy schema.table (desc) from /my/file.txt WITH DELIMITER '|' HEADER CSV " db
psql -U user -p 1234 -h hostname -c "\copy schema.table ('desc') from /my/file.txt WITH DELIMITER '|' HEADER CSV " db
psql -U user -p 1234 -h hostname -c "\copy schema.table ("desc") from /my/file.txt WITH DELIMITER '|' HEADER CSV  db

I get the same error everytime:

ERROR:  syntax error at or near "desc"

I can't seem to get around it. Is there something that I am missing?

Vao Tsun · Accepted Answer · 2017-07-11 11:05:04Z

1

just escape double quotes, like here:

vao@vao-X102BA:~$ psql -c "copy s1(\"desc\") from stdin;"
Enter data to be copied followed by a newline.
End with a backslash and a period on a line by itself.
>> b
>> \.
COPY 1
vao@vao-X102BA:~$ psql
psql (9.6.3)
Type "help" for help.

vao=# select * from s1;
 i | desc
---+------
   | a
   | b

(2 rows)

answered Jul 11, 2017 at 11:05

Vao Tsun

52.5k13 gold badges114 silver badges149 bronze badges

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

Collectives™ on Stack Overflow

Postgres 9 \COPY FROM Command - Reserved Keyword

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related