Re: [GENERAL] Re: temp table creation

Bruce Momjian <pgman@candle.pha.pa.us>

From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alfonso Peniche <alfonso@iteso.mx>, PostgreSQL-documentation <pgsql-docs@postgresql.org>
Date: 2001-03-20T00:17:36Z
Lists: pgsql-general
This should be in the docs somewhere.  Is it?


> Alfonso Peniche <alfonso@iteso.mx> writes:
> > In that case, how could I create a temporary table from plpgsql?
> 
> CREATE [TEMP] TABLE foo AS SELECT ...
> 
> This is equivalent to SELECT INTO [TEMP] foo in regular SQL, and
> does not change meaning in plpgsql.
> 
> 			regards, tom lane
> 


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026