PostgreSQL support

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:

• AWS RDS
• Microsoft Azure
• Google Cloud SQL