PostgreSQL support

Applies to: 8.x versions, Article available also for: 9.x (current), 7.x
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 9.x (current).

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.