Zet - How do I create random data using sql?
How do I create random data using sql?
Look at Dom’s example setting activity_type
UPDATE road_segment
SET activity_type =
CASE
WHEN random() < 0.25 THEN 'Walked'
WHEN random() < 0.5 THEN 'Driven'
WHEN random() < 0.75 THEN 'Hybrid'
ELSE 'Other'
END;
#postgres #sql