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

From A.Bhuvaneswaran
Subject Re: What is the scope of a temp table?
Date
Msg-id Pine.LNX.4.44.0304161050080.1087-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to What is the scope of a temp table?  (Guy Fraser <guy@incentre.net>)
List pgsql-sql
> 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



pgsql-sql by date:

Previous
From: Adam Sherman
Date:
Subject: Re: Percentage of Total Occurances
Next
From: Rajesh Kumar Mallah
Date:
Subject: Re: plpgsql