> -----Original Message-----
> From: frank_lupo [mailto:frank_lupo@email.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.