Re: PGAdmin Version 2.1
От | Dave Page |
---|---|
Тема | Re: PGAdmin Version 2.1 |
Дата | |
Msg-id | CA+OCxoxS8_rFokUTpiGtuk+TMO2eC=tcKfc=dmShTY0JGxN_yg@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: PGAdmin Version 2.1 (Melvin Davidson <melvin6925@yahoo.com>) |
Ответы |
Re: PGAdmin Version 2.1
|
Список | 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 classThat 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
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
В списке pgadmin-support по дате отправления: