sql - PostgreSQL 查询——列不存在

Question

我正在尝试使用临时表更新表。

  Schema   |         Name         |   Type   |  Owner   
------------+----------------------+----------+----------
 pg_temp_11 | tmp_x                | table    | postgres
 public     | entities             | table    | postgres

---

但是我收到了这个错误:

UPDATE entities SET "Name" = "tmp_x.Name" FROM tmp_x WHERE "entities.Ent_ID" = "tmp_x.Ent_ID";
ERROR:  column "tmp_x.Name" does not exist -- the column Name exists
LINE 1: UPDATE entities SET "Name" = "tmp_x.Name" FROM tmp_x WHERE "...

问题是什么？表列周围的引号？

Answer 1

您用双引号将多个单独的对象括起来。如果您使用对象定界符(双引号)，它们需要出现在每个项目上，而不是出现在整个组合上:

UPDATE entities SET "Name" = "tmp_x"."Name" FROM tmp_x WHERE "entities"."Ent_ID" = "tmp_x"."Ent_ID";