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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
