title: How to create and call temp table in redshift
body: <p>I want to create a temp table and call this temp table in redshift? I have tried this one but got an error message.</p>
  
  <pre><code>select  top 10 * into #a from public.item_activity where item_act_timestamp &lt; DATEADD(day,-1,getdate());
  
  select * from #a
  </code></pre>
  
  <blockquote>
    <p>"ERROR: 42P01: relation "#a" does not exist"</p>
  </blockquote>