Data Types supported by Redshift database

SMALLINT,INT2
INTEGER,INT,INT4
BIGINT,INT8

NUMERIC
DECIMAL
REAL
FLOAT4
DOUBLE PRECISION
FLOAT,FLOAT8

DATE
TIMESTAMP
TIMESTAMPZ,TIMESTAMP WITH TIME ZONE

CHAR,CHARACTER
NCHAR
VARCHAR
NVARCHAR
BPCHAR
TEXT

BOOLEAN

GEOMETRY

See also  Arithmetic Functions in Redshift database