What’s New in dbForge Studio for PostgreSQL, v3.2

Last modified: March 28, 2025

Connectivity improvements

Added support for PostgreSQL 17
Added support for AlloyDB
Added support for Supabase
Added support for Google Cloud
Added support for Azure Cosmos DB for PostgreSQL
Added support for the rds-ca-rsa2048-g1 SSL/TLS certificate for connecting to PostgreSQL servers on Amazon Web Services

Text Editor enhancements

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 enhancements

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 enhancements

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 enhancements

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

User-reported and internal bug fixes

Fixed metadata retrieval that could fail on specific server versions (D154740)
Improved support for special values in datetime datatypes (D139021)
Added support for ON UPDATE CASCADE and ON DELETE CASCADE clauses to be applied during the re-creation of foreign keys for data synchronization (D155811, D167879)
Added support for the parsing of the DISTSTYLE keyword in CREATE TABLE statements for Amazon Redshift (D151002)
Fixed an issue with the deletion of words during multi-line selection in the editor (D149219)
Fixed an issue with the parsing of the LIKE ANY construct (D148245)
Fixed an issue with multi-line selection caused by tab characters in the text (D143567)
Fixed an issue with the recovery of a deleted selection when performing an undo operation in the editor (D146741)
Fixed the quoting of case-sensitive column names during the insertion from the completion list (D144980)
Improved the display of the completion list where every owner name was attached to the corresponding element name; now owners are displayed in a separate column (D143565)
Added the ability to delete an empty line using the Shift+Delete key combination (D141949)
Fixed the deselection behavior in the text editor shown in a floating window (D146113)
Improved the insertion of date and time data from the clipboard to a cell in Data Editor (D148236)
Improved the export of large volumes of blob data to a file from Data Viewer (D170044)
Fixed repeated password requests for SSH connections (D164049)
Improved error handling behavior when describing objects for code completion (D161730)
Added the ability to display subobjects for DML triggers in Database Explorer (D152468)
Improved the display and calculation of the optimal width of the row number column in Data Editor (D142475)
Fixed the display of data in Data Viewer when double-clicking it in Data Editor (D147103)
Fixed an issue that occurred when deleting a command in an SQL document (D146736)
Fixed an issue that occurred after restoring an SQL document upon opening the Studio (D148363)
Fixed a lag in Data Editor that occurred during the execution of a query against a large table in the paginal mode (D146744)
Fixed the ‘canceling statement due to user request’ error that occurred during multiple repeated executions of a query in an SQL document (D145274)
Fixed an issue with table names that occurred when generating INSERT commands during data export (D146069)
Fixed an issue with unnecessary quotation marks being added to values when copying data from Data Editor (D146287)
Fixed an issue with the failed selection of the last line in an SQL document (D146340)
Fixed the selection of the current database in the Data Export wizard (D146737)
Added the ability to close a floating window using the Ctrl+F4 key combination (D145259)
Fixed an issue with the ‘Execute Current Statement’ command that occurred after modifying the query text in an SQL document (D141953)
Fixed a lag that occurred when pointing to a table name in an SQL document (D146110)
Improved the display of the cursor (D145395)
Added diagnostics to determine the cause of errors (D147104)
Added the auto-selection of the column type for suggestions (D141625)
Fixed the behavior of the option ‘Activate Data Editor after query execution’ (D118496, D130770)
Fixed the issue with incorrect text selection in an SQL document (D146751, D145094, D145398)
Extended the error message displayed in the Error List window with additional information (D141957, D75630)