postgresql - "user"PostgreSQL 附近的语法错误，即使引用了用户

Question

在 postgres 上获取这个:

syntax error at or near ""user""

对于以下内容:

insert into "user" ("id", "email") values ('1', 'foo@example.com') on conflict do update "user" set "id" = '1', "email" = 'foo@example.com'

玩了一段时间，不知道语法错误在哪里。感谢您的帮助。

Answer 1

显然，您不能在 ON CONFLICT UPDATE SET 子句中指定表名。以下似乎有效:

insert into "user" ("id", "email") values ('1', 'foo@example.com')
on conflict do update set "id" = '1', "email" = 'foo@example.com'

syntax here :

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