title: Use postgres CTE in multiple queries
body: <p>I can use a CTE in a single query like this</p>
  
  <pre><code>with mycte as (...)
    insert into table1 (col1) select col1 from mycte where col1 in
      (select col1 from mycte)
  </code></pre>
  
  <p>But what if I want to use <code>mycte</code> in multiple queries? How can I make something like this work?</p>
  
  <pre><code>with mycte as (...)
    insert into table1 (col1) select col1 from mycte where col1 in
      (select col1 from mycte),
    insert into table2 (col1) select col1 from mycte where col1 in
      (select col1 from mycte)
  </code></pre>