Inserting and Creating Tables Using INSERT/SELECT INTO

INSERT INTO 

INSERT INTO allows the output of a SELECT to be used to insert values into an existing table.  

INSERT INTO table [ ( column [, ...] ) ] SELECT query

 INSERT INTO name_list (name) SELECT name FROM stud;

SELECT * from name_list ;  

name ------ fred 

tom

john

lisa

(4 rows)