X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9D905D98C8 for ; Thu, 6 Oct 2005 00:36:43 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03378-10 for ; Thu, 6 Oct 2005 03:36:36 +0000 (GMT) Received: from mx1.surnet.cl (mx1.surnet.cl [216.155.73.180]) by svr1.postgresql.org (Postfix) with ESMTP id 9F398D9B62 for ; Thu, 6 Oct 2005 00:36:34 -0300 (ADT) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx1.surnet.cl with ESMTP; 05 Oct 2005 23:37:15 -0400 Received: from alvh.no-ip.org (200.85.218.33) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 433A601F001F0949; Wed, 5 Oct 2005 23:36:34 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 75A52C2DC18; Wed, 5 Oct 2005 23:36:36 -0400 (CLT) Date: Wed, 5 Oct 2005 23:36:36 -0400 From: Alvaro Herrera To: David Durham Cc: pgsql-admin@postgresql.org Subject: Re: create table like syntax Message-ID: <20051006033636.GA12593@surnet.cl> Mail-Followup-To: David Durham , pgsql-admin@postgresql.org References: <4344942A.3040506@vailsys.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <4344942A.3040506@vailsys.com> User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.455 required=5 tests=[AWL=-0.295, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376] X-Spam-Level: * X-Archive-Number: 200510/75 X-Sequence-Number: 19147 On Wed, Oct 05, 2005 at 10:04:10PM -0500, David Durham wrote: > is there a syntax that would look something like: > > create table newTable like oldTable without indexes || records || > constraints with indexes || records || constraints > > built into postgres? What do you want to do with it? If I understand what you want to do, it is supported as long as you use ; in place of your ||. -- Alvaro Herrera Architect, http://www.EnterpriseDB.com "La fuerza no está en los medios físicos sino que reside en una voluntad indomable" (Gandhi)