postgresql multiple insert with select query

Question

i need to perform a insert query for multiple rows whereby the first column is a numeric and identical value and the second values are queried from another table.

something like

insert into table (33, select col2 from another_table);

can this be accomplished with a single statement?

SQLMenace · Accepted Answer · 2010-05-31 16:44:22Z

13

like this

insert into table 
select 33, col2 from another_table;

answered May 31, 2010 at 16:44

SQLMenace

136k25 gold badges212 silver badges227 bronze badges

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

2 Comments

pcent Over a year ago

in this example, the table being inserted must have only two fields: one that will receive the numeric and another of the same type as col2 from another_table

luigi7up Over a year ago

I was wondering if there was a possibility to specify columns explicitly like: insert into table (id, col2_name) values((select 33, col2 from another_table)) ?

Ivan · Accepted Answer · 2016-11-16 15:34:28Z

1

If you want to specify columns in your insert query, you should use this syntax:

INSERT INTO table (id, col2_name) (SELECT 33, col2 FROM another_table);

answered Nov 16, 2016 at 15:34

Ivan

113 bronze badges

Collectives™ on Stack Overflow

postgresql multiple insert with select query

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related