Re: What is the scope of a temp table? - Mailing list pgsql-sql

From Guy Fraser
Subject Re: What is the scope of a temp table?
Date
Msg-id 3E9EC5D9.2070509@incentre.net
Whole thread Raw
In response to Re: What is the scope of a temp table?  ("A.Bhuvaneswaran" <bhuvansql@myrealbox.com>)
List pgsql-sql
Thank you.

That is what I wanted to know.

Guy

A.Bhuvaneswaran wrote:

>>I have never created a "temp table" before, because I was not sure when 
>>the table was available and if or when it would be automaticly dropped.
>>
>>Could someone let me know becuase I could probaly use them in data 
>>massaging routines.
>>    
>>
>
>Temp tables are alive in the current session only. Once the session is
>closed, the temp tables created in that session are dropped.
>
>regards,
>bhuvaneswaran
>  
>
...snip...



pgsql-sql by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Re: planner question..
Next
From: Manfred Koizar
Date:
Subject: Re: getting rid of "Adding missing FROM-clause entry...."