Which objects can be compared and synchronized?

Last modified: January 30, 2023

dbForge Studio for PostgreSQL supports the comparison and deployment of the following PostgreSQL object types:

Note

The dbForge tool supports PostgreSQL servers from 8.3 to 14 versions. However, for PostgreSQL servers 8.4-9.2 versions, Materialized Views and Stored Procedures are not supported. For PostgreSQL servers 9.3-9.6 versions, the dbForge tool doesn’t support Stored Procedures.

dbForge Studio for PostgreSQL fully supports Amazon Redshift. The only exception is that Materialized Views are not displayed in Database Explorer and can not be compared and synchronized with the Schema Compare tool.

Tables

The dbForge tool supports table columns, datatypes and constraints: Primary Key, Unique Key, Foreign Key, CHECK, NOT NULL, DEFAULT.

The following DDL parameters are not supported: LIKE, INHERITS, WITH, ON COMMIT, TABLESPACE, and index parameters in UNIQUE, PRIMARY KEY, and EXCLUDE constraints.

Note

The unsupported parameters are not described, displayed in the DDL diff pane, or synchronized.

Views

dbForge Studio for PostgreSQL supports views columns and datatypes.

The TEMPORARY parameter is not supported.

Materialized Views

dbForge Studio for PostgreSQL supports materialized views columns and datatypes.

The following DDL parameters are not supported: column_name, WITH ( storage_parameter [= value] [, … ] ), and TABLESPACE.

Functions

The following DDL parameters are not supported: configuration_parameter, WITH ( attribute [, … ] ), WINDOW. The IMMUTABLE, STABLE, and VOLATILE attributes are also not supported.

Stored Procedures

The TRANSFORM { FOR TYPE type_name } [, … ] } parameter is not supported.

Sequences

The TEMPORARY parameter is not supported.

Note

The dbForge tool also allows you to compare and synchronize not only database objects but also their comments where they are available.