RE: pga2: problem schema

> 
> 
> > -----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.
> 

Ok, it's a good solution.

Please chage you in cvs.

----
Question mail list
I resubscribe to pgadmin haker and pgadmin support, using pgadmin-hackers-request@postgresql.org,
pgadmin-support-request@postgresql.org,
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