SqlDBM Help Center

All CollectionsDatabase Object and Feature Support

Amazon Redshift Support Summary

Amazon Redshift Support Summary

Amazon Redshift object and data type support summary

S

Written by Serge Gershkovich

Updated over a year ago

This article summarizes the features, objects, properties, and data types that are available for Amazon Redshift projects.

Features

Direct connect

Objects and properties

Schemas
Tables
- Constraints
  - PK
    Comment/Description
  - FK
  - UNIQUE
    Comment/Description
  - DistKey
    Distribution style
    Auto
    Even
    Key
    All
    Distribution column
    Comment/Description
  - SortKey
    Compound
    Interleaved
    Comment/Description
- Options
  - Backup
- Comment/Description
- Post Script
Columns
- 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

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

See also: