How to insert column of other table in postgresql

Question

I want to insert a column of other table and one parameter of this table have a hard coded value. I want to iterate this value with the each return value of other table column. How can i do this with insert query?

let 3,4,6 is the return column value of other table.

insert into table(value1,value2)
values (2,select id from table2)

Return column

2       3
2       4
2       6

Your question alludes to two tables, and you have only shown one. The question is hard to follow without appropriate sample data and desired results. — Gordon Linoff
– Gordon Linoff, Commented Jul 25, 2020 at 13:45

user330315 · Accepted Answer · 2020-07-25 13:51:15Z

4

Get rid of the values clause:

insert into table(value1,value2)
select 2, id 
from table2

answered Jul 25, 2020 at 13:51

user330315

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

Collectives™ on Stack Overflow

How to insert column of other table 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