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