Documentation

Table of Contents:


    Google Cloud SQL for PostgreSQL support

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

    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

    Learn more

    Connect to Google Cloud SQL

    Found issue with this article? Comment below
    0
    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).
    Accept