- Integer
- Real
- Text
- Bytea
- Date
- Timestamp (implemented as timestamp with time zone)
- Time (implemented as time with time zone)
- Interval
- Boolean
- Geometry
- Geometry (tipoGeometrico, SRC) (a parameterized type)
- Intrange (implemented as int8range)
- Intmultirange (implemented as int8multirange)
- Numrange
- Nummultirange
- Tsrange (implemented as tstzrange)
- Tsmultirange (implemented as tstzmultirange)
- Daterange
- Measure
- Measure(unidadeMedida) (a parameterized type; the unit can be any string referencing a unit—e.g., "ºC". When not specified, each value must include both the measure and the unit.)
- Category
- Category(vocabulario) (a parameterized type where the parameter references a vocabulary from the current or another schema. When not specified, values must include both the term and the vocabulary.)
Additionally, besides the above, in the Data Type field you can use any enumerated or complex data type defined by the user in the current schema or in another schema already created in the same database. To reference another schema, use the notation schema.data_type
.