title: PostgreSQL dump Temp table
body: <p>I created a <strong>temp table</strong> in my PostgreSQL DB using the following query  </p>
  
  <pre><code>SELECT * INTO TEMP TABLE tempdata FROM data WHERE id=2004;
  </code></pre>
  
  <p>Now I want to create a backup of this temp table <code>tempdata</code>.<br>
  So i use the following command line execution  </p>
  
  <pre><code>"C:\Program Files\PostgreSQL\9.0\bin\pg_dump.exe" -F t -a -U my_admin -t tempdata myDB &gt;"e:\mydump.backup"  
  </code></pre>
  
  <p>I get a message saying  </p>
  
  <pre><code>pg_dump: No matching tables were found  
  </code></pre>
  
  <p>Is it possible to create a dump of <code>temp tables</code>?<br>
  Am I doing it correctly?  </p>
  
  <p>P.S. : I would also want to restore the same.I don't want to use any extra components.</p>
  
  <p>TIA.</p>