Where are user-defined types stored/viewed

From: <btober(at)seaworthysys(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Where are user-defined types stored/viewed
Date: 2003-09-29 12:35:55
Message-ID: 64686.216.238.112.88.1064838955.squirrel@$HOSTNAME
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

The new type DOES show up in the result when I run

select * from pg_type order by typname

but I see only the name itself (and a lot of "*id" columns that probably
reference something relevant), but I don't know how to get the actual
definition back so that I can use an existing type definition as the
basis for modification when application design changes are required.

~Berend Tober

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sven Schwyn 2003-09-29 12:36:00 Re: Modification Dates
Previous Message Sven Schwyn 2003-09-29 12:25:34 Re: Modification Dates