PostgreSQL user-defined types in the structure editor and sidebar

[datlechin]

Problem

Enums, composite types and domains are invisible. A column using one shows the type name and nothing else: there is no way to see its definition, list the types in a schema, or create one without writing DDL.

Proposed solution

• A Types section under each schema beside Functions and Triggers, listing enums, composites, domains and ranges.
• Open a type to see its definition, and edit an enum's labels.
• Offer user-defined types in the column type picker in the structure editor.
• The same treatment on other engines with comparable types where it costs little.

Alternatives considered

Query pg_type by hand.

Related database type

PostgreSQL