Re: Insert on create table - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: Insert on create table
Date
Msg-id 1053118605.2618.2.camel@billy
Whole thread Raw
In response to Re: Insert on create table  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-novice
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


pgsql-novice by date:

Previous
From: Matej Cepl
Date:
Subject: Re: Problems with join (no such attribute, but it exists)
Next
From: Nabil Sayegh
Date:
Subject: 7.2.1 => 7.3.2