Menu
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.
809
The PostgreSQL user-defined data type is used to generate user-defined data types with the help of Create DOMAIN and CREATE TYPE. The CREATE DOMAIN command is used to generate a user-defined data type with constraints such as CHECK, NOT NULL, etc.
Step 1: Open the pgAdmin app and enter your password to connect to the database server. Step 2: Expand the Servers tree and then the Databases tree. The tree expands to show a list of all databases on the server. Click the Properties tab to see more information about each database.
Description. CREATE TYPE registers a new data type for use in the current database. The user who defines a type becomes its owner. If a schema name is given then the type is created in the specified schema. Otherwise it is created in the current schema.
You just need to enable viewing types through menu File → Options... → Browser and checking Types:
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.
151
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
