Postgresql multiple insert with selected query

Question

I need to execute an insert query for multiple rows in which the first column is a numeric and identical value, and the second value is retrieved from another table.

sort of

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

can this be done with a single statement?

Answer 1

like this

insert into table 
select 33, col2 from another_table;

Answer 2

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

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