MySql 和 PostgreSQL 根据一张表update另一张表数据

1:MySQL脚本

UPDATE TABLE A JOIN table2 b ON A.busid = b.busid 
SET A.district = b.district;

2：PostgreSQL脚本

①、单列

UPDATE TABLE A 
	SET ( district ) = ( SELECT district FROM table2 b WHERE A.site = b.site ) 
WHERE
	bustype = 1;

②、多列

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