Horton
Menu

Re: Re: temp table creation

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alfonso Peniche <alfonso@iteso.mx>
Cc: pgsql-general@postgresql.org
Date: 2001-02-15T15:35:58Z
Lists: pgsql-general 
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