pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Guy Fraser <guy@incentre.net>
To: pgsql-sql@postgresql.org
Subject: Re: What is the scope of a temp table?
Date: Thu, 17 Apr 2003 09:18:49 -0600
Message-ID: <3E9EC5D9.2070509@incentre.net> (raw)
References: <Pine.LNX.4.44.0304161050080.1087-100000@Bhuvan.bksys.co.in>

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...




view thread (3+ messages)

Message-ID: <3E9EC5D9.2070509@incentre.net>
Permalink:  ../3E9EC5D9.2070509@incentre.net/
Also on:    postgresql.org/message-id/3E9EC5D9.2070509@incentre.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: guy@incentre.net
  Subject: Re: What is the scope of a temp table?
  In-Reply-To: <3E9EC5D9.2070509@incentre.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox