| From: | Nabil Sayegh <nas(at)e-trolley(dot)de> |
|---|---|
| To: | Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> |
| Cc: | Yovko Ilchev Yovkov <yyovkov(at)vipsolutions(dot)net>, pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Insert on create table |
| Date: | 2003-05-16 20:56:45 |
| Message-ID: | 1053118605.2618.2.camel@billy |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Am Fre, 2003-05-16 um 22.12 schrieb Jeff Eckermann:
> --- Yovko Ilchev Yovkov <yyovkov(at)vipsolutions(dot)net>
> wrote:
> > Can anyone tell what I am in need of to do smthng
> > like:
> > When: CREATE TABLE table_1 (...);
> > Automaticaly to execute: INSERT INTO TABLE newtables
> > (name) VALUE (table_1);
What about:
CREATE TABLE table_1 as SELECT name FROM foo;
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : www.e-trolley.de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nabil Sayegh | 2003-05-16 20:58:15 | Re: Insert on create table |
| Previous Message | Jeff Eckermann | 2003-05-16 20:12:01 | Re: Insert on create table |