Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id E074CB5DBFC for ; Thu, 25 Aug 2011 06:35:12 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 15131-06 for ; Thu, 25 Aug 2011 09:35:06 +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 C711EB5D91F for ; Thu, 25 Aug 2011 06:35:03 -0300 (ADT) Received: (qmail 11934 invoked from network); 25 Aug 2011 09:35:01 -0000 Received: from unknown (HELO php09) (10.134.37.58) by relay3 with SMTP; 25 Aug 2011 09:35:01 -0000 Received: (qmail 24896 invoked by uid 64140); 25 Aug 2011 09:35:01 -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:35:01 +0100 Message-ID: <20110825103501.10735sujl05pno79@mail.sapo.pt> Date: Thu, 25 Aug 2011 10:35:01 +0100 From: ppdcc@sapo.pt To: pgsql-sql@postgresql.org 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.011 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, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201108/116 X-Sequence-Number: 35784 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