From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "frank_lupo" <frank_lupo(at)email(dot)it> |
Cc: | "pgadmin-hackers" <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: pga2: problem schema |
Date: | 2003-06-06 07:32:23 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B844AFDE@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
> -----Original Message-----
> From: frank_lupo [mailto:frank_lupo(at)email(dot)it]
> Sent: 06 June 2003 07:44
> To: Dave Page
> Cc: pgadmin-hackers
> Subject: RE: pga2: problem schema
>
> the selection in psql is:
>
> ------------------
> SELECT n.nspname as "Schema",
> pg_catalog.format_type(t.oid, NULL) AS "Name",
> pg_catalog.obj_description(t.oid, 'pg_type') as
> "Description" FROM pg_catalog.pg_type t
> LEFT JOIN pg_catalog.pg_namespace n ON n.oid =
> t.typnamespace WHERE (t.typrelid = 0 OR (SELECT c.relkind =
> 'c' FROM pg_catalog.pg_class c WHERE c.oid = t.typrelid)) AND
> t.typname !~ '^_'
> AND pg_catalog.pg_type_is_visible(t.oid)
> ORDER BY 1, 2;
> ------------------
>
Hmm, what about:
SELECT oid, *, pg_get_userbyid(typowner) as typeowner FROM pg_type WHERE
typtype != 'd' AND (typtype != 'c' OR (typtype = 'c' AND typrelid = 0))
That includes typtype = 'c', but only if typrelid = 0 which I think
should solve Marc's problem.
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Michel POURE | 2003-06-06 08:09:51 | Re: pgAdmin3 ab sofort in Deutsch! |
Previous Message | frank_lupo | 2003-06-06 06:44:27 | RE: pga2: problem schema |