[GENERAL] create table/type

[Hicham G. Elmongui]

is there a way to create a table with a certain type?

CREATE TYPE typename AS (id integer, name varchar);

and something like

CREATE TABLE names OF TYPE typename.


Is there a syntax to support this?

thanks,
--h



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster