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 0633CDA2CE for ; Thu, 6 Oct 2005 00:04:19 -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 95464-10 for ; Thu, 6 Oct 2005 03:04:12 +0000 (GMT) Received: from chrobd01.vailsys.com (chrobd01.vailsys.com [63.210.102.138]) by svr1.postgresql.org (Postfix) with ESMTP id 78579DA2C6 for ; Thu, 6 Oct 2005 00:04:09 -0300 (ADT) Received: from dfsfbd06.vail (dfsfbd06.vail [192.168.129.190]) by chrobd01.vailsys.com (Postfix) with ESMTP id CAC04497E for ; Wed, 5 Oct 2005 22:04:06 -0500 (CDT) Received: from [172.16.5.91] (unknown [172.16.5.91]) by dfsfbd06.vail (Postfix) with ESMTP id 993EB55B1 for ; Wed, 5 Oct 2005 22:04:06 -0500 (CDT) Message-ID: <4344942A.3040506@vailsys.com> Date: Wed, 05 Oct 2005 22:04:10 -0500 From: David Durham User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: create table like syntax Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200510/73 X-Sequence-Number: 19145 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?