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

From
Subject Re: Where are user-defined types stored/viewed
Date
Msg-id 64907.216.238.112.88.1064926667.squirrel@$HOSTNAME
Whole thread Raw
In response to Re: Where are user-defined types stored/viewed  (Richard Huxton <dev@archonet.com>)
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

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 by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: pg_hba.conf
Next
From: Arguile
Date:
Subject: Re: Functional index performance question