title: PostgreSQL: Select several queries into same table
body: <p>Good day,</p>
  
  <p>I have a table with some records that should be deleted.  I would like to keep track of the deleted records and place such records in a new table.  I would like to do the following:</p>
  
  <pre><code>SELECT * INTO TEMP FROM TABLE WHERE criteria &lt; 1;
  </code></pre>
  
  <p>And then delete these records with DELETE query.  Later on I would like to do a new SELECT query:</p>
  
  <pre><code>SELECT * INTO TEMP FROM TABLE WHERE new_criteria &gt; 2;
  </code></pre>
  
  <p>And then delete those records as well.  I will be working from only one table and just place the selected records into the same, new table (just for reference).</p>
  
  <p>Thanks!</p>