CODE EXAMPLE FOR SQL

insert data from another table

#PostgreSQL
INSERT INTO table1 (column11, column12, ...)
SELECT column21, column22, ...
FROM table2
[WHERE condition];