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