Data Types
Hyper has a rich set of native data types available to users.
The table below shows all the built-in general-purpose data types. Most of the alternative names listed in the "Aliases" column are the names supported by Hyper for compatibility reasons with Postgres.
Name | Aliases | Description |
---|---|---|
BIGINT | INT8 | signed eight-byte integer |
BOOLEAN | BOOL | Boolean value with ternary logic (true/false/unknown) |
BYTES | binary data ("byte array") | |
CHARACTER [ (n) ] | CHAR [ (n) ] | fixed-length character string |
CHARACTER VARYING (n) | VARCHAR (n) | variable-length character string with limit |
DATE | calendar date (year, month, day) | |
DOUBLE PRECISION | FLOAT8 | double precision floating-point number (8 bytes) |
INTEGER | INT , INT4 | signed four-byte integer |
INTERVAL | time span; not supported in Tableau | |
NUMERIC [ (p, s) ] | DECIMAL [ (p, s) ] | exact numeric of selectable precision |
SMALLINT | INT2 | signed two-byte integer |
TEXT | variable-length character string | |
TIME [ WITHOUT TIME ZONE ] | time of day (no time zone) | |
TIMESTAMP [ WITHOUT TIME ZONE ] | date and time (no time zone) | |
TIMESTAMP WITH TIME ZONE | TIMESTAMPTZ | date and time, including time zone |
GEOGRAPHY | a geography object |
Links to detailed documentation:
📄️ Boolean Type
Hyper provides the standard SQL type boolean. The boolean type can
📄️ String Types
Hyper supports three genera-purpose string types:
📄️ Numeric Types
Numeric types consist of two-, four-, and eight-byte integers, as well
📄️ Date/Time Types
Hyper supports the set of SQL date and time types shown in the table below.
📄️ Binary Data Type
The bytes data type allows storage of binary strings.