Goboxe <hadzramin(dot)ar(at)gmail(dot)com> writes:
>> Let say I created a new type:
>> CREATE TYPE compfoo AS (f1 int, f2 text);
>> How can I view its definition?
In psql, \d works:
regression=# CREATE TYPE compfoo AS (f1 int, f2 text);
CREATE TYPE
regression=# \d compfoo
Composite type "public.compfoo"
Column | Type
--------+---------
f1 | integer
f2 | text
regards, tom lane