Advertisement
Guest User

Untitled

a guest
May 21st, 2019
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. DO $$
  2. BEGIN
  3. FOR x IN 1..100 LOOP
  4. INSERT INTO cars (brand_id, color_id, engine_id) VALUES ((select id from brand order by random() limit 1),(select id from color order by random() limit 1),(select id from engine order by random() limit 1 ) );
  5. END LOOP;
  6. END;
  7. $$;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement