Skip to main content

Amazon Redshift Support Summary

SqlDBM Support
Updated

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

 

Features

 

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

  • Views
    • Types:
      • Regular
      • Late binding (WITH NO SCHEMA BINDING)
    • Columns
      • Comment/Description
    • 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:

Related articles