On Monday 29 September 2003 13:35, [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
