由於 Postresql 不支援在更新查詢中加入,因此使用兩個表之間的連線更新查詢

    update <SCHEMA_NAME>.<TABLE_NAME_1> AS A
    SET <COLUMN_1> = True       
    FROM <SCHEMA_NAME>.<TABLE_NAME_2> AS B 
    WHERE 
        A.<COLUMN_2> = B.<COLUMN_2> AND
        A.<COLUMN_3> = B.<COLUMN_3>