PostgreSQL Maestro online Help
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.
|
Partners
Download
Buy
