title: Multiple Inserts into Table with same primary key at once - PostgreSQL
body: <p>I want to insert multiple values with same primary key in a table at once.</p>
  
  <p>How it can be done in postgresql.</p>
  
  <p>I am fetching the primary key from another table as well multiple values are also from another table.</p>
  
  <p>I am trying out this.</p>
  
  <pre><code>INSERT INTO ceh_grouped_alert_map (grp_id, alert_id, created_date) 
  SELECT (select grp_id from ceh_grouped_alerts where alert_name = 'ABC') id, x
  FROM unnest((select alert_id from ceh_alerts where alert_name = 'ABC')) x, '2017-03-17 10.00.00.000'
  </code></pre>
  
  <p>But not able to do so.</p>