What's the syntax to do the following.
I do it on Oracle all the time!
create table temp as select * from other_table
This creates a new table temp with the same strucure and copies all the data into it.
Or I can do
create table temp as col1,col2,ect from other_table