Data Types Supported by Column-Store Tables

Table 1 lists the common data types supported by column-store tables.

**Table 1** Data types supported by column-store tables
Category	Data Type	Description	Length
Numeric data	smallint	Small integer, also called INT2	2
	integer	Typical choice for integer, also called INT4	4
	bigint	Big integer, also called INT8	8
	decimal	Arbitrary precision type	Variable length
	numeric	Arbitrary precision type	Variable length
	real	Single-precision floating point	4
	double precision	Double-precision floating point	8
	smallserial	Two-byte auto-incrementing integer	2
	serial	Four-byte auto-incrementing integer	4
	bigserial	Eight-byte auto-incrementing integer	8
Money	money	Currency amount	8
Character data	character varying(n), varchar(n)	Variable-length string	Variable length
	character(n), char(n)	Fixed-length string	n
	character, char	Single-byte internal type	1
	text	Variable-length string	Variable length
	nvarchar2	Variable-length string	Variable length
	clob	Big text object	Variable length
Date/Time	timestamp with time zone	Date and time (with time zone)	8
	timestamp without time zone	Date and time	8
	date	Date and time (Oracle compatibility mode); date (other compatibility modes)	When using Oracle compatibility mode, the storage space is 8 bytes, whereas in other compatibility modes, it is 4 bytes.
	time without time zone	Time within one day	8
	time with time zone	Time within one day (with time zone)	12
	interval	Time interval	16
JSON	json	-	-
JSON	jsonb	-	-
XML	xml	-	-
RoaringBitmap	-	Efficient bitmap, which supports the bitmap calculation of datasets of the int type.	Variable length

The supported array types are related to the GUC parameter enable_vectorization_array.

If enable_vectorization_array (this parameter is only available to clusters of version 9.1.1.100 or later) is enabled, column-store tables support the following array types: bool, tiny int, small int, int, bigint, float4, float8, numeric, text, char, varchar, nvarchar2, bpchar, tinterval, smalldatetime, date, time, timestamp, timestamptz, interval, and timetz.
If enable_vectorization_array is disabled, array types cannot be created for column-store tables.
Other data types that are not mentioned are not supported currently.

Parent Topic: Data Types