How to insert with loops in postgresql

Question

I am trying to insert a number of rows to a table where values came from a select query

insert into article_rel (x_id, y_id) VALUES (12, (SELECT id from table where name = 'string')

this should be the same as executing this

insert into article_rel (x_id, y_id) VALUES (12, 1)
insert into article_rel (x_id, y_id) VALUES (12, 3)
insert into article_rel (x_id, y_id) VALUES (12, 4)

and so on.

I saw this How to use a SQL for loop to insert rows into database? but I'm not sure how can this help me

Thanks in advance,

Rimas · Accepted Answer · 2014-10-08 06:13:10Z

4

Use this query:

INSERT INTO article_rel (x_id, y_id)
  SELECT 12, id
  FROM table_name
  WHERE name = 'string'

answered Oct 8, 2014 at 6:13

Rimas

6,0332 gold badges28 silver badges40 bronze badges

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

Collectives™ on Stack Overflow

How to insert with loops in postgresql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related