"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> CREATE TABLE inventory (
> invnum character(8) NOT NULL,
> description character(255)
> );
> CREATE TABLE test (
> inv inventory
> );
Table columns can't be composite types. It's possible this will work in
7.5, if anyone does more work on it in the next month, but it hasn't
worked since Berkeley days. (And the feature they had didn't work as
you expect, either.)
regards, tom lane