Re: Re: temp table creation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alfonso Peniche <alfonso(at)iteso(dot)mx>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: temp table creation
Date: 2001-02-15 15:35:58
Message-ID: 2395.982251358@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

Alfonso Peniche <alfonso(at)iteso(dot)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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Joe Zangara 2001-02-15 23:08:50 error
Previous Message Alfonso Peniche 2001-02-15 15:26:25 Re: temp table creation

Browse pgsql-general by date

  From Date Subject
Next Message Michael Ansley 2001-02-15 15:54:07 RE: DSN-less connection to Postgres-database
Previous Message Alfonso Peniche 2001-02-15 15:26:25 Re: temp table creation