Resolved: PGSQL: Selecting values from first table and inserting them as one of the params to the second table

In this post, we will see how to resolve PGSQL: Selecting values from first table and inserting them as one of the params to the second table

Question:

Is is possible to do something like this or similar in PostgreSQL?
In short I want to select ids from table_1 and insert them as a second param of insert to table_2. The first of inserted values will be a const of varchar type

Best Answer:

You’d use INSERT INTO ... SELECT ...:

If you have better answer, please add a comment about this, thank you!

Source: Stackoverflow.com