From: | Nabil Sayegh <postgresql(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:58:15 |
Message-ID: | 1053118695.2759.1.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
--
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 | Tom Lane | 2003-05-16 21:11:37 | Re: \copy command |
Previous Message | Nabil Sayegh | 2003-05-16 20:56:45 | Re: Insert on create table |