Re: PGAdmin Version 2.1 - Mailing list pgadmin-support

From Dave Page
Subject Re: PGAdmin Version 2.1
Date
Msg-id CA+OCxoxS8_rFokUTpiGtuk+TMO2eC=tcKfc=dmShTY0JGxN_yg@mail.gmail.com
Whole thread Raw
In response to Re: PGAdmin Version 2.1  (Melvin Davidson <melvin6925@yahoo.com>)
Responses Re: PGAdmin Version 2.1  (Melvin Davidson <melvin6925@yahoo.com>)
List pgadmin-support


On Tue, Jan 30, 2018 at 2:57 PM, Melvin Davidson <melvin6925@yahoo.com> wrote:
>Effectively, a composite type that can represent a row in a class

That may be true, but users expect to see "user defined types", not tables and views. As such, the query driving the display should be something like:

WITH types AS
( SELECT reltype
    FROM pg_class
WHERE relkind = 'c'
)
SELECT *
  FROM pg_type
 WHERE oid in (SELECT reltype
                 FROM types)
 ORDER BY typname;

No need to duplicate everything else.

No - if you switch on "Show system objects", it will display system objects such as row types. That's the whole point of the switch (which is off by default). 

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgadmin-support by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: PGAdmin Version 2.1
Next
From: Melvin Davidson
Date:
Subject: Re: PGAdmin Version 2.1