SQL

insert data from another table

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

Insert into table from another table

INSERT INTO table_name (column1, column2, column3) 
SELECT 'Test1', column, 'Test3'
FROM table_name;

create table and insert values from another table

CREATE TABLE new_table AS
SELECT * 
FROM   old_table;