> -----Original Message----- > From: frank_lupo [mailto:[EMAIL PROTECTED] > 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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
