title: Copying a row in the same table without having to type the 50+ column names (while changing 2 columns)
body: <p>During my job, I usually have to copy rows while changing their primary key and giving them a new stamp and maybe changing the foreign key. </p>
  
  <p>The problem is I don't want to type all the column names while doing;</p>
  
  <pre><code>insert into table_name
  select pk_seq.nextval, 
         'foreign-key', 
         col3,
         col4...col51
    from table_name
   where pk_id = "original_primary_key"
  </code></pre>
  
  <p>And if i do * in the select statement i won't be able to update the first 2 columns...</p>
  
  <p>Is there any way to do how I want to do it?</p>