Re: Insert on create table

Am Fre, 2003-05-16 um 22.12 schrieb Jeff Eckermann:
> --- Yovko Ilchev Yovkov <yyovkov@vipsolutions.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