Re: Where are user-defined types stored/viewed

<btober@seaworthysys.com> writes:
> After I execute a command like
> CREATE TYPE employee_wage_journal_sum AS (supplier_pk integer,
>         employee_pk integer,
>         hourly_dollars double precision,
>         annual_dollars double precision);

> I don't see the new type show up anywhere in pgAdminII.

Probably not.  Stand-alone composite types (like the above) are a new
feature in 7.3, and pgAdminII likely doesn't know about them.

You might try pgAdmin III, which just got out of beta I believe.

> but I see only the name itself (and a lot of "*id" columns that probably
> reference something relevant), but I don't know how to get the actual
> definition back so that I can use an existing type definition as the
> basis for modification when application design changes are required.

There's always "pg_dump -s" to extract such stuff.

            regards, tom lane