Manal Helal <manalorama(at)gmail(dot)com> writes:
> I defined a composite type and forgot its structure, data fields names
> and data types. Is there any command that can define that for me?
psql's \d command, for one.
regression=# create type fooey as (f1 int, f2 text);
CREATE TYPE
regression=# \d fooey
Composite type "public.fooey"
Column | Type
--------+---------
f1 | integer
f2 | text
regards, tom lane