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.
- Using Navigation bar and Toolbar
- Creating/editing base type
- Browsing object dependencies
- Editing base type description
- Viewing DDL definition
- Setting object permissions