| From: | Masse Jacques <jacques(dot)masse(at)bordeaux(dot)cemagref(dot)fr> |
|---|---|
| To: | 'Bruce Momjian' <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pl/pgsql create table |
| Date: | 2002-08-27 16:50:10 |
| Message-ID: | 0B87317EA62BD211A02A00A0C9DFB7EC9B5ED1@hermes.bordeaux.cemagref.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Sorry, I omitted to say that 'foo' was a some complicated select statement
(working alone ...)
___________________________________________
Jacques Massé
Tel. 33 (0)5 57 89 08 11 - Fax 33 (0)5 57 89 08 01
-----Message d'origine-----
De : Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
Envoyé : mardi 27 août 2002 17:39
À : Masse Jacques
Cc : pgsql-general
Objet : Re: [GENERAL] pl/pgsql create table
Masse Jacques wrote:
> I find exactly the same with
> EXECUTE ''CREATE TABLE tmp as select foo'';
How about:
EXECUTE ''CREATE TABLE tmp as select * FROM foo'';
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-08-27 17:02:25 | Re: pl/pgsql create table |
| Previous Message | Dario Fumagalli | 2002-08-27 16:45:19 | Data files become huge fast |