Re: [GENERAL] Re: temp table creation - Mailing list pgsql-docs

From Alfonso Peniche
Subject Re: [GENERAL] Re: temp table creation
Date
Msg-id 3AB78514.FF3BB188@iteso.mx
Whole thread Raw
In response to Re: [GENERAL] Re: temp table creation  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-docs
Yes Bruce, IT IS In the new documentation (7.1 release), but not in previous
versions. If you want me to be specific, it's in the reference manual under
SQL Commands - CREATE TABLE AS.....

Cheers

Bruce Momjian wrote:

> 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


pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Re: [GENERAL] Re: temp table creation
Next
From: "willy lubamba"
Date:
Subject: unsubscribe