Lots of you asked me how to create a table with millions of rows in postgres, here is in details

docker run -e POSTGRES_PASSWORD=postgres --name pg postgres
docker exec -it pg psql -U postgres
create table temp (t);
insert into temp (t) select random()*100 from generate_series(0,100000)

#postgresql #database #postgres

Create Postgres Table with a MILLION Rows (from Scratch)
9.40 GEEK