This article summarizes the features, objects, properties, and data types that are available for Amazon Redshift projects.
Features
Objects and properties
-
-
Constraints
-
Options
Backup
Comment/Description
Post Script
-
Data type (see summary of types below)
(NOT) NULL
-
Identity
Seed
Increment
-
Compression encoding
Bytedict
Delta
Delta32k
Lzo
Mostly8
Mostly16
Mostly32
Raw
Runlenght
Text255
Text32k
Zstd
Default
Comment/Description
-
-
Views
- Types:
- Regular
- Late binding (WITH NO SCHEMA BINDING)
- Columns
- Comment/Description
- Comment/Description
- Types:
Data types
-
Numeric Data Types
DECIMAL
NUMERIC
INTEGER
INT
SMALLINT
BIGINT
FLOAT
FLOAT4
FLOAT8
DOUBLE PRECISION
REAL
-
String & Binary Data Types
VARCHAR
CHAR
-
Logical Data Types
BOOLEAN
-
Date & Time Data Types
DATE
TIMESTAMP
TIMESTAMPTZ