PostgreSQL support

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

Supported versions

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

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

Ask our community Contact support Report issue

Found issue with this article? Comment below

0

There are no comments. Click here to write the first comment.