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 5083030F152 for ; Tue, 17 Jun 2003 17:02:04 +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 60004-01 for ; Tue, 17 Jun 2003 14:01:53 -0300 (ADT) Received: from mwinf0502.wanadoo.fr (smtp4.wanadoo.fr [193.252.22.26]) by svr1.postgresql.org (Postfix) with ESMTP id 85A1830ED11 for ; Tue, 17 Jun 2003 14:01:53 -0300 (ADT) Received: from gina (unknown [193.253.61.219]) by mwinf0502.wanadoo.fr (SMTP Server) with ESMTP id 70483E8003EA for ; Tue, 17 Jun 2003 19:01:52 +0200 (CEST) From: Guillaume LELARGE Organization: traduc.org To: pgsql-sql@postgresql.org Subject: Re: CREATE table1 FROM table2 Date: Tue, 17 Jun 2003 19:10:56 +0000 User-Agent: KMail/1.5 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200306171910.56181.gleu@wanadoo.fr> X-Archive-Number: 200306/191 X-Sequence-Number: 13949 Hi, Le Mardi 17 Juin 2003 20:46, Achilleus Mantzios a =E9crit : > On 17 Jun 2003, Rado Petrik wrote: > > How I create table1 from other table2 . > > > > "cp table1 table2" > > create table table2 as select * from table1; > Another way would be: select * into table2 from table1; (See=20 http://www.postgresql.org/docs/view.php?version=3D7.3&idoc=3D0&file=3Dsql-s= electinto.html). --=20 Guillaume .