Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2A4892E35E3 for ; Wed, 6 Feb 2008 15:44:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 01464-01-10 for ; Wed, 6 Feb 2008 15:43:53 -0400 (AST) Received: from dukecmmtao05.coxmail.com (dukecmmtao05.coxmail.com [68.99.120.90]) by postgresql.org (Postfix) with ESMTP id 2ED9A2E3C69 for ; Wed, 6 Feb 2008 15:43:40 -0400 (AST) Received: from [127.0.0.1] (really [70.166.0.90]) by dukecmmtar01.coxmail.com (InterMail vM.6.01.06.01 201-2131-130-101-20060113) with ESMTP id <20080206194031.NCI4652.dukecmmtar01.coxmail.com@[127.0.0.1]> for ; Wed, 6 Feb 2008 14:40:31 -0500 Message-ID: <47AA0D2E.5040303@acm.org> Date: Wed, 06 Feb 2008 11:40:30 -0800 From: TJ O'Donnell User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: PostgreSQL - SQL Subject: Create Table xtest (like xtype) Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/33 X-Sequence-Number: 30124 I know I can create a table using names and types from an existing table. Create Table xtable (a Integer, b Text); Create Table xtest (Like xtable); This works just fine. I want to create a table having the same column names and types as an existing new datatype. Create Type xtype As (a Integer, b Text); Create Table xtest (Like xtype); ERROR: "xtype" is a composite type Is that possible some other way? TJ O'Donnell http://www.gnova.com