Re: What is the scope of a temp table?

From: Guy Fraser <guy(at)incentre(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: What is the scope of a temp table?
Date: 2003-04-17 15:18:49
Message-ID: 3E9EC5D9.2070509@incentre.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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...

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Manfred Koizar 2003-04-17 15:30:06 Re: getting rid of "Adding missing FROM-clause entry...."
Previous Message Rajesh Kumar Mallah 2003-04-17 15:12:16 Re: planner question..