Thread: Create Table xtest (like xtype)
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
"TJ O'Donnell" <tjo@acm.org> writes: > Create Type xtype As (a Integer, b Text); > Create Table xtest (Like xtype); > ERROR: "xtype" is a composite type Hmmm ... as you see, that's disallowed, but offhand it seems like it wouldn't be very hard to allow it. It might be as simple as relaxing the relkind check. regards, tom lane
Considering how related Created Types and Tables are (at least conceptually) it seems like a good idea to allow Created Types to be used in the Like clause. At least it would help me and make maintaining my db easier and cleaner. TJ O'Donnell http://www.gnova.com/ > "TJ O'Donnell" <tjo@acm.org> writes: >> Create Type xtype As (a Integer, b Text); >> Create Table xtest (Like xtype); >> ERROR: "xtype" is a composite type > > Hmmm ... as you see, that's disallowed, but offhand it seems like it > wouldn't be very hard to allow it. It might be as simple as relaxing > the relkind check. > > regards, tom lane >