Added support for the rds-ca-rsa2048-g1 SSL/TLS certificate for connecting to PostgreSQL servers on Amazon Web Services
Text Editor
Added parameter info and quick info for functions and procedures
Added suggestions for foreign key columns in ON DELETE SET NULL and ON DELETE SET DEFAULT clauses
Added suggestions for columns declared in scripts for foreign keys within CREATE TABLE and ALTER TABLE clauses
Added suggestions for existing triggers, ENABLE REPLICA, ENABLE ALWAYS, and potential owners in ALTER EVENT TRIGGER clauses
Added suggestions for existing triggers in DROP EVENT TRIGGER clauses
Added suggestions for CREATE OR REPLACE, FOR EACH ROW, FOR EACH STATEMENT, DEFERRABLE INITIALLY DEFERRED, and DEFERRABLE INITIALLY IMMEDIATE in CREATE TRIGGER clauses
Added suggestions for triggers along with the tables and views they are based on in ALTER TRIGGER clauses
Redesigned Query History, whose toolbar now includes an updated range selection and a button that clears the history
Added the ability to duplicate, remove, and join current lines in SQL documents using shortcuts
Schema and Data Compare
Added support for foreign key columns in ON DELETE SET NULL and ON DELETE SET DEFAULT clauses in Schema Compare
Added support for the comparison and synchronization of DML and event (DDL) triggers in Schema Compare
Improved the comparison and synchronization of UNIQUE constraints in Schema Compare
Added full support for the comparison and synchronization of CHECK constraints in Schema Compare
Implemented access to the automated generation of comparison reports directly from the Comparison Report wizard in Schema Compare and Data Compare
Added new customization options for the automated generation of comparison reports in Schema Compare and Data Compare
Data Generator
Added new basic generators to Data Generator, including Files Folder, Lorem Ipsum, Shuffled Text, and Text File
Added new smart generators to Data Generator in the following categories: Business, IT, Payment, Location, Product, Health, and Personal
Added a new option in Data Population Wizard that appends a timestamp to the name of the data population script file
Database Explorer
Added an option to delete database objects directly from the context menu in Database Explorer
Added an option to generate the DDL of materialized views in Amazon Redshift from the context menu
Others improvements
Implemented direct data export from the Data Editor grid to an Excel file from the context menu
Implemented an option that sets the value of a cell to a unique identifier from the Data Editor context menu
Added quick access to PostgreSQL-related demos and tutorials of Devart Academy from the Help menu