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