Do you know of any functional difference between the 'copy' statement and a 'insert into emp2 (select * from emp)' or a 'create table emp2 as (select * from emp)'? A developer suprised me with the copy command and I'm trying to figure out what are the advantages/disadvantages of it vs the alternatives.

Thanks,
-Jason