How to copy data from csv file into table with name user in Postgres?

Question

I am trying to copy user information from csv file into Postgres database and the table name is user.

I can import data from pgAdmin manually. However if I run the COPY user(columns) FROM csvfile... command, it is giving me Syntax error at user.

Is there any solution for this?

When I renamed the user table to usert, it worked and I was able to insert data.

Is the issue because of the table name?

fphilipe · Accepted Answer · 2019-08-19 12:12:05Z

1

user is a reserved key word. Thus, you'll have to specify the table identifier as a quoted identifier it in double quotes:

COPY "user" (columns) FROM csvfile...

For more, consult the doc on Lexical Structure, specifically the section Identifiers and Key Words.

answered Aug 19, 2019 at 12:12

fphilipe

10.1k1 gold badge42 silver badges55 bronze badges

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

Collectives™ on Stack Overflow

How to copy data from csv file into table with name user in Postgres?

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