更新字段到对应表相应的值
update identities
set extern_uid = tmp.username
from(select id, username from users)
as tmp (id, username)
where identities.user_id = tmp.id
update identities
set extern_uid = tmp.username
from(select id, username from users)
as tmp (id, username)
where identities.user_id = tmp.id