title: Bulk insert in more than one column in PostgreSQL
body: <p>I have one bulk insert query </p>
  
  <pre><code>insert into table1(shift) select value from table2 where transid='shiftid'
  </code></pre>
  
  <p>This query is inserting all the shift values from table2 into my table1 shift column.</p>
  
  <p>But what if I want to insert record in multiple columns in table1 but my select query will return only one column, say:</p>
  
  <pre><code>select value from table1 where transid in ('shiftid','gradeid','currencyid')
  </code></pre>
  
  <p>It will return one column with all the values. But I want to insert:</p>
  
  <pre><code>insert into table1(shift,grade,currency) ...........
  </code></pre>
  
  <p>Can anyone fill the .... for me? I hope you understand my requirement.</p>