CODEWITHSUNDEEP
postgresqlpgadmin
Larry
Larry

Reputation: 11919

Can’t see user-defined database “types" in pgAdmin

Is there a graphical way to create/manipulate/view special database types in PgAdmin?

For example, in PostgreSQL we have:

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.

Upvotes: 41

Views: 11657

Answers (1)

Grzegorz Szpetkowski
Grzegorz Szpetkowski

Reputation: 37914

You just need to enable viewing types through menu File → Options... → Browser and checking Types:

enter image description here

According to pgAdmin's documentation:

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.

Upvotes: 71

Related Questions