title: PostgreSQL: Column "crab_id" Specified More than Once
body: <p>With PostgreSQL call,</p>
  
  <pre><code>CREATE TABLE condor_xrootd AS
         SELECT * FROM condor INNER JOIN xrootd_ext
         ON (
  xrootd_ext.CRAB_Id = condor.CRAB_Id AND
  REPLACE(condor.CRAB_ReqName, '_', ':') = xrootd_ext.CRAB_ReqName
  );
  </code></pre>
  
  <p>I get the error,</p>
  
  <pre><code>$ psql condor -f ./sql/inner_join.sql 
  psql:./sql/inner_join.sql:6: ERROR:  column "crab_id" specified more than once
  </code></pre>
  
  <p>Which is understandable because each table has a Crab_Id column. I would like to be able to do my inner join without having to specify the columns because I have around 400 columns in the two tables combined.</p>
  
  <p>Please let me know if I can somehow get rid of this error without listing columns individually.</p>
  
  <p>EDIT:</p>
  
  <p>I forgot to mention that speed <strong>and stability</strong> is crucial here as my join might take several days.</p>