Re: Where are user-defined types stored/viewed
От | |
---|---|
Тема | Re: Where are user-defined types stored/viewed |
Дата | |
Msg-id | 64907.216.238.112.88.1064926667.squirrel@$HOSTNAME обсуждение исходный текст |
Ответ на | Re: Where are user-defined types stored/viewed (Richard Huxton <dev@archonet.com>) |
Список | 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 Based on the output produced using your advice, I came up the the following query to help me list my type definitions: CREATE VIEW public.complex_types AS SELECT n.nspname, c.relname, a.attname, pg_catalog.format_type(a.atttypid, a.atttypmod), a.attnotnull, a.atthasdef, a.attnum, nspacl FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_catalog.pg_attribute a ON a.attrelid = c.relfilenode WHERE pg_catalog.pg_table_is_visible(c.oid) AND c.relkind = 'c' ORDER BY n.nspname, c.relname, a.attnum ~Berend Tober
В списке pgsql-general по дате отправления: