Re: pga2: problem schema

OK, done.

Regards, Dave.

> -----Original Message-----
> From: frank_lupo [mailto:frank_lupo@email.it]
> Sent: 06 June 2003 10:04
> To: Dave Page
> Cc: pgadmin-hackers
> Subject: 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