Re: Where are user-defined types stored/viewed

On Monday 29 September 2003 13:35, btober@seaworthysys.com wrote:
> 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);
>
> where does this definition get stored, and what query can I run to get
> teh definition back as output?
>
> I don't see the new type show up anywhere in pgAdminII.

In psql:
\d emplokee_wage_journal_sum

If you start psql with -E it will show you the query it uses to show this too.

--
  Richard Huxton
  Archonet Ltd