do $$
begin
for d in 0..1000000 loop
INSERT INTO CARS (c_brand,c_engine, c_color) values ((select brand from brand order by random() limit 1),(select engine from engine order by random() limit 1),(select color from color order by random() limit 1));
end loop;
end;
$$
;