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