PostgreSQL根据一张表update另一张表

多字段更新

方式1

update table a set (column01,colum02, column03) = (select b.column01， b.column02,b.column03 from table b where a.column= b.column)

方式2

update table a set column01 = t.column01 , column02 = t.column02 , column03 = t.column03 from table t where a.column04 = t.column04 and a.column05 = t.column05

单字段更新

update table a set column = ( select b.column from table b where a.id = b.id )