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.
Want to find out more?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for PostgreSQL.
All features
Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.