| 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: | Whole Thread | Raw Message | 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
| 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 |