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 881F1DA56F for ; Fri, 7 Oct 2005 10:04:53 -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 88237-08 for ; Fri, 7 Oct 2005 13:04:49 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id D8963DA559 for ; Fri, 7 Oct 2005 10:04:51 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j97D4mTX061577 for ; Fri, 7 Oct 2005 13:04:48 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j97Cb3Yd085795 for pgsql-admin@postgresql.org; Fri, 7 Oct 2005 12:37:03 GMT (envelope-from news) From: Gaetano Mendola X-Newsgroups: pgsql.admin Subject: Re: create table like syntax Date: Fri, 07 Oct 2005 14:36:51 +0200 Organization: Hub.Org Networking Services Lines: 19 Message-ID: <43466BE3.40200@bigfoot.com> References: <4344942A.3040506@vailsys.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: David Durham User-Agent: Thunderbird 1.4 (Windows/20050908) In-Reply-To: <4344942A.3040506@vailsys.com> To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.521 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.299] X-Spam-Level: X-Archive-Number: 200510/89 X-Sequence-Number: 19161 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? > Try this: create table newTable as select * from oldTable limit 0; Regards Gaetano Mendola