Re: What is the scope of a temp table?

From: "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>
To: Guy Fraser <guy(at)incentre(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: What is the scope of a temp table?
Date: 2003-04-16 05:21:14
Message-ID: Pine.LNX.4.44.0304161050080.1087-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-04-16 05:26:35 Re: plpgsql
Previous Message pginfo 2003-04-16 04:43:34 Re: changing column size and type.