PostgreSQL数据库根据关联字段用一张表更新另一张表数据

1、更新单列数据

update table1 A set (column1) = 
    (select column1 from table2 B where a.relColumn = b.relColumn )

2、更新多列数据

UPDATE TABLE a SET ( column01, colum02, column03 ) = 
    ( SELECT b.column01， b.column02, b.column03 FROM table2 b
         WHERE a.relColumn = b.relColumn)

版权声明：本文为Sdnu08gis原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。