Syntax error in postgres sql insert statement

Question

In postgres sql, I have this

INSERT INTO user (email, password)
values ('joe', 'test');

seems simple enough, but I get this

ERROR:  syntax error at or near "user"
LINE 1: INSERT INTO user (email, password)
                    ^

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

ERROR: syntax error at or near "user"
SQL state: 42601
Character: 13

I have a table called user, but I don't understand what's going on.

Does anyone know?

Thanks

That's what happens when you name tables using reserved words. — Ken White
– Ken White, Commented May 2, 2016 at 1:11

Pedro Lobito · Accepted Answer · 2016-05-02 02:29:18Z

7

I have a table called user, but I don't understand what's going on.

user is a PostgreSQL reserved key word, try quoting the table name:

INSERT INTO "user" (email, password)

edited May 2, 2016 at 2:29

answered May 2, 2016 at 1:04

Pedro Lobito

99.8k36 gold badges274 silver badges278 bronze badges

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

Comments

rogerdpack · Accepted Answer · 2018-11-06 18:52:31Z

0

Got the same error message once, it meant I was using the wrong quotes, I had it like this:

 INSERT INTO tableName (columns) VALUES (‘string’)

when it should be

 INSERT INTO tableName (columns) VALUES ('string')

Some kind of copy and paste fail. FWIW.

answered Nov 6, 2018 at 18:52

rogerdpack

67.7k40 gold badges290 silver badges409 bronze badges

Collectives™ on Stack Overflow

Syntax error in postgres sql insert statement

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related