Re: Where are user-defined types stored/viewed - Mailing list pgsql-general

From Richard Huxton
Subject Re: Where are user-defined types stored/viewed
Date
Msg-id 200309291424.24647.dev@archonet.com
Whole thread Raw
In response to Where are user-defined types stored/viewed  (<btober@seaworthysys.com>)
Responses Re: Where are user-defined types stored/viewed
List pgsql-general
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Time problem again?
Next
From: Horak Daniel
Date:
Subject: Re: CASE tools