Documentation

Table of Contents:


    PostgreSQL support

    2018-04-19 2018-09-13

    Supported versions

    Versions: 9.3, 9.4, 9.5, 9.6, 10

    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

    • rules are not imported
    • trigger functions are grouped with standard functions
    • dependencies are imported only from views

    Limitations

    Following schema elements currently are not supported:

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

    Supported cloud databases

    Dataedo should work with all cloud instances of PostgreSQL database. We have tested it with the following services:

    Found issue with this article? Comment below
    Comments (0)