Установить случайное поле в таблицу postgresql

do
$$
declare rec record;
begin
        for rec in (select id from users) loop
        update users set company_id  = (select id from companies order by random() limit 1) where id=rec.id;
        end loop;
end;
$$