Generate 100 rows with random data using SQL query

Question

I use this SQL query to insert 1 row of data:

INSERT INTO public.tasks (id, business_name, meta_title, status, title, type) VALUES (
    '10'::bigint, 'business name 1'::character varying, 'meta title 1'::character varying, 'active'::character varying, 'title 1'::character varying, 'merchant'::character varying)
    returning id;

Is it possible with 1 SQL query to insert 100 rows with random data into Postgre table?

What do you mean by random data?

Gordon Linoff
– Gordon Linoff

2021-08-31 00:29:04 +00:00
Commented Aug 31, 2021 at 0:29 — Gordon Linoff
– Gordon Linoff, Commented Aug 31, 2021 at 0:29
random characters of data

Peter Penzov
– Peter Penzov

2021-08-31 00:29:51 +00:00
Commented Aug 31, 2021 at 0:29 — Peter Penzov
– Peter Penzov, Commented Aug 31, 2021 at 0:29

Meir Tseitlin · Accepted Answer · 2021-08-31 00:52:28Z

5

INSERT into tasks SELECT generate_series(1,100) AS id, 
md5(random()::text) AS business_name, 
md5(random()::text) AS meta_title,
md5(random()::text) AS status,
md5(random()::text) AS title,
md5(random()::text) AS type

answered Aug 31, 2021 at 0:52

Meir Tseitlin

2,0483 gold badges19 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Peter Penzov Over a year ago

For Date field how I can generate random date?

Meir Tseitlin Over a year ago

You can do different things with random() function and dates. I.e. if you want random day from the last year, you can do something like this: select date(now() - floor(random() * 365) * '1 day'::interval)

Collectives™ on Stack Overflow

Generate 100 rows with random data using SQL query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related