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

From Nabil Sayegh
Subject Re: Insert on create table
Date
Msg-id 1053118695.2759.1.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
--
 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: Jeff Eckermann
Date:
Subject: Re: Insert on create table
Next
From: Tom Lane
Date:
Subject: Re: \copy command