Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Simon Pills: "Someone finally invented an intuitively used and easily customized PostgreSQL database administration tool! Keep up the good work. I will be in touch. I am able to do this horrendous work because your software enabled me to create a new database with all necessary objects in several minutes! I am sure that I have found what I really need".
Armin Braunstein: "Also I must say, that your PostgreSQL Maestro tool is the best tool for PostgreSQL I have seen. For general I am really happy about the tool and how it works".

More

Add your opinion

PostgreSQL Maestro online Help

Prev Return to chapter overview Next

Composite and Enum Types

PostgreSQL Maestro represents composite types and enum types as different objects, but work with them is similar. So, we describe them in one manual section.

 

A composite type describes the structure of a row or record; it is in essence just a list of field names and their data types. PostgreSQL allows values of composite types to be used in many of the same ways that simple types can be used. For example, a column of a table can be declared to be of a composite type.

 

Enumerated (enum) types are data types that comprise a static, ordered set of values. They are equivalent to the enum types supported in a number of programming languages. An example of an enum type might be the days of the week, or a set of status values for a piece of data.

 

 

New composite and enum types are created within Create Composite Type Wizard and Create Enum Type Wizard respectively.  In order to run these wizards you should either

 

select the Object | Create Database Object... main menu item;
select the Composite Type or Enum Type icon in the Create Database Object dialog

or

select the Composite (Enum) Types list or any object from that list in the explorer tree;
select the Create New Composite (Enum) Type... item from the popup menu

or

open the schema in Schema Editor and the Composite Types (Enum Types) tab there;
press the Insert key or select the Create New Composite (Enum) Type item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

       

To create a new composite type with the same properties as one of the existing composite type has:

 

select the Object | Duplicate Database Object... main menu item;
follow the instructions of Duplicate Object Wizard.

 

 

 

Composite Types and Enum Typed are edited within Composite Type Editor and Enum Type Editor respectively. In order to run these editors you should either

 

select the composite type (enum type) for editing in the explorer tree (type the first letters of the type name for quick search);
select the Edit Composite (Enum) Type ... item from the popup menu

or

open the schema in Schema Editor and the Composite (Enum) Types tab there;
select the type to edit;
press the Enter key or select the corresponding item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

 

 

 

To drop a composite or enum type:

 

select the type to drop in the explorer tree;
select the corresponding item from the popup menu

or

open the schema in Schema Editor and the Composite Types (Enum Types) tab there;
select the type to drop;
press the Delete key or select the corresponding item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar)

 

and confirm dropping in the dialog window.

 



Prev Return to chapter overview Next