Syntax error near "user" PostgreSQL, even though user is quoted

Question

Getting this on postgres:

syntax error at or near ""user""

For the following:

insert into "user" ("id", "email") values ('1', '[email protected]') on conflict do update "user" set "id" = '1', "email" = '[email protected]'

Been playing with it for a while, not sure where the syntax error is. Thank you for your help.

@Lexib0y No, it shouldn’t.

Sami Kuhmonen
– Sami Kuhmonen

2017-12-16 22:03:10 +00:00
Commented Dec 16, 2017 at 22:03 — Sami Kuhmonen
– Sami Kuhmonen, Commented Dec 16, 2017 at 22:03

thor · Accepted Answer · 2017-12-16 22:01:27Z

2

Apparently, you can't specify the table name in the ON CONFLICT UPDATE SET clause. The following seems to work:

insert into "user" ("id", "email") values ('1', '[email protected]')
on conflict do update set "id" = '1', "email" = '[email protected]'

The syntax here:

....
DO UPDATE SET { column_name = { expression | DEFAULT } |
                ( column_name [, ...] ) = ( { expression | DEFAULT } [, ...] ) |
                ( column_name [, ...] ) = ( sub-SELECT )
              } [, ...]
          [ WHERE condition ]

answered Dec 16, 2017 at 22:01

thor

22.7k33 gold badges108 silver badges199 bronze badges

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

Comments

Laurenz Albe · Accepted Answer · 2017-12-16 22:01:47Z

1

Remove the "user" after ON CONFLICT DO UPDATE.

answered Dec 16, 2017 at 22:01

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Collectives™ on Stack Overflow

Syntax error near "user" PostgreSQL, even though user is quoted

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