PostgreSQL, condition on column from INSERT?

Question

PostgreSQL

Good afternoon!
I will lay out at once an example of a code which does not work. How to make it possible to add a condition on a column from the INSERT table to WHERE?

INSERT INTO table1 (
    column1
)
SELECT column2
FROM table2
WHERE (column2 = table1.column3)

Answer 1

JOIN ordinary or IN/EXISTS

INSERT INTO table1 (
    column1
)
SELECT column2
FROM table2
WHERE column2 IN (SELECT table1.column3 FROM table1)