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
or
or
To create a new composite type with the same properties as one of the existing composite type has:
|
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
or
|
To drop a composite or enum type:
or
and confirm dropping in the dialog window.
|