postgreSQL: insert multiple rows where only one column value changes

Question

I have the following queries:

    insert into TABLE1(a,b,c,d) VALUES('first','second','third',100);
    insert into TABLE1(a,b,c,d) VALUES('first','second','third',101);
    insert into TABLE1(a,b,c,d) VALUES('first','second','third',102);
    insert into TABLE1(a,b,c,d) VALUES('first','second','third',103);

colums a,b and c would always have same values across all rows. I got 100,101,102 and 103 from a select statement from another table.

    select id from TABLE2;        //returns (100,101,102,103).

Can I do this using a single query?

Ken · Accepted Answer · 2017-09-15 17:43:45Z

13

The following query allows you to insert multiple rows based on the results of a query on another table.

INSERT INTO TABLE1 (a, b, c, d) SELECT 'first', 'second', 'third', id FROM TABLE2;

answered Sep 15, 2017 at 17:43

Ken

4634 silver badges8 bronze badges

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

2 Comments

Twelfth Over a year ago

Good first SQL answer Ken. Welcome to Stack

Ken Over a year ago

@Twelfth Thanks!

Collectives™ on Stack Overflow

postgreSQL: insert multiple rows where only one column value changes

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