postgresql 在 pgAdmin 中看不到用户定义的数据库“类型”
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/7271875/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Can’t see user-defined database “types" in pgAdmin
提问by Larry
Is there a graphical way to create/manipulate/view special database types in PgAdmin?
是否有图形方式在 PgAdmin 中创建/操作/查看特殊数据库类型？
For example, in PostgreSQL we have:
例如，在 PostgreSQL 中，我们有：
CREATE TYPE compfoo AS (f1 int, f2 text);
CREATE TYPE compfoo AS (f1 int, f2 text);
I've noticed pgAdmin almost shows everything graphically, such as triggers, views, functions, and of course tables, but I couldn't find the types that I created.
我注意到 pgAdmin 几乎以图形方式显示所有内容，例如触发器、视图、函数，当然还有表，但是我找不到我创建的类型。
回答by Grzegorz Szpetkowski
You just need to enable viewing types through menu File → Options... → Browser and checking Types:
您只需要通过菜单 File → Options... → Browser 启用查看类型并检查Types：
According to pgAdmin's documentation:
根据 pgAdmin 的文档：
The list of check boxes is used to select which object types to show in the browser tree. By default, only the most commonly used object types are shown. Reducing the number of object types shown can increase the speed of pgAdmin when querying the system catalogs. Use the Default button to reset the list to its default settings.
复选框列表用于选择要在浏览器树中显示的对象类型。默认情况下，仅显示最常用的对象类型。减少显示的对象类型数量可以提高 pgAdmin 在查询系统目录时的速度。使用默认按钮将列表重置为其默认设置。
