Documentation

Table of Contents:


    Azure Database for PostgreSQL support (beta)

    2018-06-16 2018-08-08

    Supported versions

    TBD

    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

    Comments

    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

    • length of data type is not imported
    • materialized views use the same icon as standard views
    • materialized view columns are not imported
    • 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

    Limitations

    Following schema elements currently are not supported:

    • Check constraints
    • Non unique indexes
    • Sequences
    • User defined types
    • Domains
    • Extensions
    • Event triggers
    • Casts
    Found issue with this article? Comment below
    Comments (0)