OK, done. Regards, Dave.
> -----Original Message----- > From: frank_lupo [mailto:[EMAIL PROTECTED] > Sent: 06 June 2003 10:04 > To: Dave Page > Cc: pgadmin-hackers > Subject: RE: pga2: problem schema > > > > > > > > > -----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. > > > > Ok, it's a good solution. > > Please chage you in cvs. > > ---- > Question mail list > I resubscribe to pgadmin haker and pgadmin support, using > [EMAIL PROTECTED], > [EMAIL PROTECTED], > but I send mail to mail list , not recive mail in my addres. > > Why? > > > Thanks > > Bye !! > Frank Lupo (Wolf) !! > > /\_ _/\ > \ o o / > --ooo-----ooo--- > > -- > GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt > > WebSite: http://users.jc-hosting.co.uk/frank_lupo > > > > -- > Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Digitalpix stampa le tue migliori foto digitali su vera carta fotografica professionale. Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1532&d=6-6 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
