Re: What is the scope of a temp table?

Поиск
Список
Период
Сортировка
От Guy Fraser
Тема Re: What is the scope of a temp table?
Дата
Msg-id 3E9EC5D9.2070509@incentre.net
обсуждение исходный текст
Ответ на Re: What is the scope of a temp table?  ("A.Bhuvaneswaran" <bhuvansql@myrealbox.com>)
Список 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 по дате отправления:

Предыдущее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: planner question..
Следующее
От: Manfred Koizar
Дата:
Сообщение: Re: getting rid of "Adding missing FROM-clause entry...."