Is there anyway to create a temporary table that will only exist in RAM and not be written to the hard drive? Or do temporary tables already do that?

That is what temp tables do... but you should only use them for throwaway data :)

Joshua D. Drake



If I can use a temporary table this way is there any simple way to merge the changes back into the original table?

_Royce Souther <mailto:[EMAIL PROTECTED]>_
_www.SiliconTao.com <http://www.SiliconTao.com>_
Let Open Source help your business move beyond.

For security this message is digitally authenticated by _GnuPG <http://www.gnupg.org>_.






--

   === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
   Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

Reply via email to