i want to insert rows from one table into another - with the using clause like so...
insert into table1 using select * from table2;
table1 has the same structure as table2 except one extra column in the end which is nulable, so the above insert will not work..
if the strucute is exactly same then i have no problem with the above insert statement.
is there a easy way to insert into table1 without listing all the columns?