X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 7280330F162 for ; Tue, 17 Jun 2003 15:32:22 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 43714-01 for ; Tue, 17 Jun 2003 12:32:12 -0300 (ADT) Received: from emo.org.tr (emo.org.tr [195.142.105.9]) by svr1.postgresql.org (Postfix) with ESMTP id 2B3C930F0FF for ; Tue, 17 Jun 2003 12:32:09 -0300 (ADT) Received: from localhost (emo.org.tr [127.0.0.1]) by emo.org.tr (8.11.6/8.11.6) with ESMTP id h5HFVqq26083; Tue, 17 Jun 2003 18:31:52 +0300 Date: Tue, 17 Jun 2003 18:31:52 +0300 (EEST) From: Devrim GUNDUZ X-X-Sender: devrim2@emo.org.tr To: Rado Petrik Cc: pgsql-sql@postgresql.org Subject: Re: CREATE table1 FROM table2 In-Reply-To: <1055863245.624.1.camel@caj> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200306/184 X-Sequence-Number: 13942 Hi, On 17 Jun 2003, Rado Petrik wrote: > How I create table1 from other table2 . CREATE TABLE table1 AS SELECT * FROM table2; will work. Regards, -- Devrim GUNDUZ devrim@gunduz.org devrim.gunduz@linux.org.tr http://www.tdmsoft.com http://www.gunduz.org