Inserting multiple same values in PostgreSQL?

Question

I've searched around and couldn't find a solution for my question - I want to insert multiple of the same values in a table?

For example, I'm using Asyncpg for python, I would do something like this:

for i in range(5):
  await execute("INSERT INTO table (column_a, column_b) VALUES (1, 2)")

while using a sequence to create unique "ID's" for each row. I understand you can use multiple values, but I want to make it so it's an arbitrary amount, how would I go about doing this?

I can't really understand what you want to do. What would be the expected result? 5 rows with the same values (1, 2)? — The Impaler
– The Impaler, Commented May 1, 2020 at 21:45
Yes, basically inserting a table with 5 rows with the same values. — Lego490
– Lego490, Commented May 1, 2020 at 21:46
Remove the WHERE section. Use: INSERT INTO table (column_a, column_b) VALUES (1, 2) — The Impaler
– The Impaler, Commented May 1, 2020 at 21:46

GMB · Accepted Answer · 2020-05-01 21:49:53Z

2

In Postgres, you can insert 5 rows at once with a single query using generate_series():

insert into mytable (column_a, column_b) 
select 1, 2
from generate_series(1, 5);

answered May 1, 2020 at 21:49

GMB

224k25 gold badges103 silver badges151 bronze badges

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

Collectives™ on Stack Overflow

Inserting multiple same values in PostgreSQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related