Re: [GENERAL] Where are user-defined types stored/viewed

2003-09-30 Thread btober
> 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

Re: [GENERAL] Where are user-defined types stored/viewed

2003-09-29 Thread Tom Lane
<[EMAIL PROTECTED]> 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 pgAdmin

Re: [GENERAL] Where are user-defined types stored/viewed

2003-09-29 Thread Richard Huxton
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 d

[GENERAL] Where are user-defined types stored/viewed

2003-09-29 Thread btober
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