Online Documentation for SQL Manager for PostgreSQL

Composite Types

A Type is internally represented as an existing type, but is considered to be a separate data type.


Composite types, or row types, are created whenever the user creates a table; it is also possible to define a "stand-alone" composite type with no associated table. A composite type is simply a list of types with associated field names. A value of a composite type is a row or record of field values. The user can access the component fields from SQL queries.


Composite Type Editor allows you to define composite type properties. It opens automatically when you create a new composite type and is available on editing an existing one.