Documentation

Table of Contents:


    PostgreSQL support

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

    Supported versions

    Versions: 9.3, 9.4, 9.5, 9.6, 10, 11

    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 and writes PostgreSQL comments from/to following objects:

    • Tables
      • Columns
    • Views
      • Columns
    • Functions

    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:

    Learn more

    Connect to PostgreSQL

    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.
    Accept