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 A054230F155 for ; Tue, 17 Jun 2003 15:32:51 +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 39167-09 for ; Tue, 17 Jun 2003 12:32:41 -0300 (ADT) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by svr1.postgresql.org (Postfix) with ESMTP id 3584230F107 for ; Tue, 17 Jun 2003 12:32:39 -0300 (ADT) Received: from matrix.gatewaynet.com (localhost [127.0.0.1]) by matrix.gatewaynet.com (8.12.5/8.12.5) with ESMTP id h5HKkWEP026265; Tue, 17 Jun 2003 18:46:37 -0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.5/8.12.5/Submit) with ESMTP id h5HKkWkl026261; Tue, 17 Jun 2003 18:46:32 -0200 Date: Tue, 17 Jun 2003 18:46:32 -0200 (GMT+2) From: Achilleus Mantzios 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/185 X-Sequence-Number: 13943 On 17 Jun 2003, Rado Petrik wrote: > Hi, > > How I create table1 from other table2 . > > "cp table1 table2" create table table2 as select * from table1; > > Thanks. > > -- ================================================================== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-210-8981112 fax: +30-210-8981877 email: achill at matrix dot gatewaynet dot com mantzios at softlab dot ece dot ntua dot gr