Re: forgot the structure of a composite type

Manal Helal <manalorama@gmail.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