Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> writes:
> psql> CREATE TYPE mytype AS (a1 int, a2 varchar(100)) ;
> is there any way to see the constitution of "mytype"
> at a later date?
regression=# CREATE TYPE mytype AS (a1 int, a2 varchar(100)) ;
CREATE TYPE
regression=# \d mytype
Composite type "public.mytype"
Column | Type
--------+------------------------
a1 | integer
a2 | character varying(100)
regression=#
regards, tom lane