Table 1 lists the data types supported by column-store tables.
Category |
Data Type |
Length |
Supported |
|---|---|---|---|
Numeric types |
smallint |
2 |
Yes |
integer |
4 |
Yes |
|
bigint |
8 |
Yes |
|
decimal |
Variable length |
Yes |
|
numeric |
Variable length |
Yes |
|
real |
4 |
Yes |
|
double precision |
8 |
Yes |
|
smallserial |
2 |
Yes |
|
serial |
4 |
Yes |
|
bigserial |
8 |
Yes |
|
Monetary types |
money |
8 |
Yes |
Character types |
character varying(n), varchar(n) |
Variable length |
Yes |
character(n), char(n) |
n |
Yes |
|
character, char |
1 |
Yes |
|
text |
Variable length |
Yes |
|
nvarchar2 |
Variable length |
Yes |
|
name |
64 |
No |
|
Date/time types |
timestamp with time zone |
8 |
Yes |
timestamp without time zone |
8 |
Yes |
|
date |
4 |
Yes |
|
time without time zone |
8 |
Yes |
|
time with time zone |
12 |
Yes |
|
interval |
16 |
Yes |
|
Large objects |
clob |
Variable length |
Yes |
blob |
Variable length |
No |
|
Others |
... |
... |
No |