Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 04228B5DC26 for ; Thu, 25 Aug 2011 06:44:43 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 54013-03 for ; Thu, 25 Aug 2011 09:44:36 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sapo.pt (relay3.ptmail.sapo.pt [212.55.154.23]) by mail.postgresql.org (Postfix) with SMTP id 48DC5B5DC0C for ; Thu, 25 Aug 2011 06:44:36 -0300 (ADT) Received: (qmail 17799 invoked from network); 25 Aug 2011 09:44:35 -0000 Received: from unknown (HELO php03) (10.134.37.52) by relay3 with SMTP; 25 Aug 2011 09:44:35 -0000 Received: (qmail 18386 invoked by uid 64140); 25 Aug 2011 09:44:35 -0000 Received: from a85-139-252-static.cpe.netcabo.pt (a85-139-252-static.cpe.netcabo.pt [85.139.252.33]) by mail.sapo.pt (Horde Framework) with HTTP; Thu, 25 Aug 2011 10:44:35 +0100 Message-ID: <20110825104435.68556k0yyck63vr7@mail.sapo.pt> Date: Thu, 25 Aug 2011 10:44:35 +0100 From: ppdcc@sapo.pt To: pgsql-sql Subject: new table with a select MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-15; DelSp="Yes"; format="flowed" Content-Disposition: inline Content-Transfer-Encoding: 7bit User-Agent: Dynamic Internet Messaging Program (DIMP) PTMail (3.3.3) X-Originating-IP: 85.139.252.33 X-PTMail-Version: 3.3.3 X-PTMail-User: as11386245@sapo.pt X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-5 required=5 tests=BAYES_40=-0.001, FREEMAIL_FROM=0.001, HK_RANDOM_ENVFROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201108/101 X-Sequence-Number: 35769 Hello to all, Can anybody tell me the sql instruction to create a new table with a select of other table? I need to create a new table based on paralell of a table of lines. Can anybody post to me a example? Can?t be a buffer, must be lines. Thanks