title: Can I copy from one table to another in Redshift
body: <p>I understand that <a href="http://docs.aws.amazon.com/redshift/latest/dg/r_COPY.html" rel="noreferrer">the COPY command</a> imports lots of data very efficiently. But copying data from one table to another with <a href="http://docs.aws.amazon.com/redshift/latest/dg/r_INSERT_30.html" rel="noreferrer">the INSERT command</a> is slow. Is there a more efficient way to copy data from one table to the other? Or should I use <a href="http://docs.aws.amazon.com/redshift/latest/dg/r_UNLOAD.html" rel="noreferrer">the UNLOAD command</a> to unload the table into S3, then COPY it back from there?</p>