Re: seeing type defination.. - Mailing list pgsql-sql

Rajesh Kumar Mallah <mallah@trade-india.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 mytypeComposite type "public.mytype"Column |          Type
--------+------------------------a1     | integera2     | character varying(100)

regression=#
        regards, tom lane