From: | frank_lupo <frank_lupo(at)email(dot)it> |
---|---|
To: | dpage <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | RE: pga2: problem schema |
Date: | 2003-06-06 09:04:22 |
Message-ID: | HG1YJA$7E578BED428773D6BD512F686F0F14E2@email.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
>
>
> > -----Original Message-----
> > From: frank_lupo [mailto:frank_lupo(at)email(dot)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(at)postgresql(dot)org, pgadmin-support-request(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-06-06 09:46:38 | Re: pga2: problem schema |
Previous Message | Jean-Michel POURE | 2003-06-06 08:09:51 | Re: pgAdmin3 ab sofort in Deutsch! |