Online Documentation for SQL Manager for PostgreSQL

Base Types


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

 

Base types are those, like int4, that are implemented below the level of the SQL language (typically in a low-level language such as C). They generally correspond to what are often known as abstract data types. PostgreSQL can only operate on such types through functions provided by the user and only understands the behavior of such types to the extent that the user describes them. Base types are further subdivided into scalar and array types. For each scalar type, a corresponding array type is automatically created that can hold variable-size arrays of that scalar type.

 

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