Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: temp table creation - Mailing list pgsql-general

From Tom Lane
Subject Re: Re: temp table creation
Date
Msg-id 2395.982251358@sss.pgh.pa.us
Whole thread Raw
In response to Re: temp table creation  (Alfonso Peniche <alfonso@iteso.mx>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Richard Huxton"
Date:
Subject: Re: last UPDATE or INSERT time of a table?
Next
From: Bruno Wolff III
Date:
Subject: regular expression substittion function?