Psql INSERT INTO .. ​​how to pass one value via SELECT and the rest are static?

Question

SQL

Hello.
Stuck on the following problem...
There is a sign:
product_id | taxon_id | position
I want to make INSERT into it, and I need to get product_id via SELECT from another table, and specify taxon_id and position with static values ​​(for example, 592 and 1).
Those. if we consider INSERT with static values:

INSERT INTO products_taxons (product_id,taxon_id,position) VALUES (3500,592,1);

instead of 3500, I want to pass the values ​​from
SELECT product_id FROM table_name;
and the values ​​for taxon_id and position are always 592 and 1.
Please help with the request or indicate where to dig. In Google, I found solutions when all data is transferred by SELECT, but I did not find SELECT + static values ​​:(

Answer 1

INSERT INTO products_taxons (product_id,taxon_id,position)
SELECT product_id, 592, 1 FROM table_name;