sql - Bulk update in Postgres -

i need update 1 table records based on one.

i tried

update      currencies set         priority_order= t2.priority_order        currencies t1 inner join  currencies1 t2 on          t1.id = t2.id 

but giving error (same query work mysql , sql server)

then tried below

update      currencies set         priority_order= (select                              priority_order                              currencies1                                                           currencies.id=currencies1.id                            ) 

it working slow, need big tables well.

any ideas?

in postgres, like:

update currencies t1     set priority_order = t2.priority_order     currencies1 t2     t1.id = t2.id;