CODE EXAMPLE FOR SQL

insert random numbers in columns postgress

update foo
   set bar = floor(random() * 9 + 1);  -- from 1 to 10, inclusive