How to copy data from table to another in Postgres

Here is the syntax for the same

Insert into table2 [column1, ...] Select * from table1;