All Collections
Database 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 week ago

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

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:

Did this answer your question?