title: Copy data from a table, into the same table with a different key
body: <p>I was curious if it was possible to take data from a table, and duplicate it but assign a new primary key</p>
  
  <p>for example, I wish to take data that has a column "question_id" which acts as the unique key for the table, and copy all of the data from the table with that question_id to the same table but with a new question_id. </p>
  
  <p>any thoughts as to if this is possible using SQL?</p>
  
  <p>my database is an ingres database</p>
  
  <p>thanks in advance </p>