Table of Contents:

    Amazon Aurora PostgreSQL support

    Applies to: 9.x (current), Article available also for: 8.x, 7.x

    Supported versions

    • Aurora PostgreSQL compatible
    • Aurora MySQL compatible - check here

    Supported schema elements and metadata

    • Tables
      • Columns
        • Data type
        • Nullable
        • Default value
      • Primary keys
        • Columns
      • Foreign keys
        • Columns
      • Triggers
        • When triggered
        • Script
    • Views
      • Columns (see tables)
      • Script
    • Materialized views
      • Script
    • User-defined Functions
      • Script
      • Parameters
      • Returned value


    Dataedo reads PostgreSQL comments from following objects:

    • Tables
      • Columns
    • Views
      • Columns
    • Functions

    Dataedo does not write comments back to PostgreSQL at this moment.

    Known Issues

    • using encoding different than UTF-8 (unicode) causes errors
    • rules are not imported
    • trigger functions are grouped with standard functions
    • dependencies are imported only from views
    • tables and views with no comments, but containing column level comments are not correctly imported. Add a table level comment to solve the issue


    Following schema elements currently are not supported:

    • Check constraints
    • Non unique indexes
    • Sequences
    • User defined types
    • Domains
    • Extensions
    • Event triggers
    • Casts

    Learn more

    Connect to Amazon Aurora

    Found issue with this article? Comment below
    There are no comments. Click here to write the first comment.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).