UPDATE table1 SET column = value FROM table2 WHERE table1.column2 = table2.column2
【PostgresSQL】同时更新两个表
原文:http://www.cnblogs.com/sekihin/p/7842617.html