dbForge Studio for PostgreSQL Revision History

2026.1.77 25-Jun-2026

User-reported bug fixes

Resolved a cyclic dependency issue for functions and triggers in Schema Comparison(#248772, #250925)
Resolved clipboard data corruption when copying HTML data with duplicate column names
Fixed the Object Filter functionality in schema comparison console mode

2026.1.39 15-May-2026

User-reported bug fixes

Fixed incorrect alphabetical sorting of foreign key columns during schema comparison and synchronization (#230326)

2026.1.31 11-May-2026

New functionality

Introduced Query Builder for visual SQL query design
Introduced Database Editor for visual database management
Introduced Schema Editor for visual schema design and management
Introduced Table Editor for visual table design and SQL preview

Schema Compare

Added Schema Mapping and Table Mapping pages to the New Schema Comparison wizard
Added Options pages to the schema comparison and synchronization wizards
Added the Discard Changes option to the Objects Filter toolbar
Added support for index comparison and synchronization on tables and materialized views
Added broader server support for comparison tasks
Improved support for GENERATED { BY DEFAULT | ALWAYS } AS IDENTITY columns

AI Assistant

Improved AI Assistant by adding support for database index metadata

Text Editor

Added the Enclose identifiers in quotes feature to the SQL Editor
Added syntax highlighting for PostgreSQL dollar-quoted blocks
Added index name suggestions in code completion
Added indexed column icons in Quick Info

Improvements

Added the ability to pin document tabs
Added the ability to restore document tab order
Enabled data generation for columns with unsupported data types

User-reported bug fixes

Fixed a syntax error related to the FETCH FIRST clause (#232775)
Added support for the dec (n, m) type in the PostgreSQL parser (#232771)
Added support for multiple SELECT result sets and RAISE NOTICE output within a single session (#232767)
Fixed an error in the data editor that occurred when executing a modified query before the previous query had finished fetching data (#194837)
Improved saving of window layouts and restoration of window positions after restarting the Studio (#236783)
Fixed the Find and Replace control to restore its settings after restart (#167346)
Removed the automatic execution of ROLLBACK when closing a connection (#198095)
Added support for the ANALYSE keyword in the EXPLAIN clause grammar (#200826)
Fixed the behavior of the "Ignore whitespace" option in the Schema Comparison Wizard (#230432)
Extended parsing support for the CREATE INDEX expression syntax to include NULLS NOT DISTINCT (u50487201)
Fixed the behavior of the "SQL Look In" option in the Find and Replace control
Updated the installation wizard to not display the "Successful Install" page during dbForge product updates

2025.3.149 25-Mar-26

User-reported bug fixes

Added support for the VARIADIC syntax for SQL Document(#227768)

2025.3.107 12-Feb-26

User-reported bug fixes

Fixed an issue that occurred when comparing string-type columns in PostgreSQL; COLLATE attribute comparison is temporarily disabled until full support is implemented

2025.3.93 29-Jan-26

User-reported bug fixes

Resolved an issue that caused identical Amazon Redshift tables to be treated as different during the schema comparison

2025.3.61 24-Dec-25

Text Editor Improvements

Added scroll bar annotations
Added an option to automatically surround selections
Improved code completion in routines to recognize local variables and parameters inside stored procedure and function bodies
Added editor support for SELECT statements
Added editor support for INSERT, UPDATE, and DELETE statements
Added editor support for the WITH clause
Added editor support for the MERGE statement
Improved code completion to support named parameters
Added camelCase formatting for identifiers

User-reported bug fixes

Fixed an issue with generating scripts that assign comments to tables (#215204)
Fixed an issue with generating data using Python
Implemented a text preview for CLOB data types instead of an icon
Fixed an issue where floating-point values lost precision when copied to Excel

2025.2.138 20-Nov-25

User-reported bug fixes

Fixed the insertion of line breaks when 'Replace with: \n' and 'Use: Regular Expressions' are selected

2025.2.109 31-Oct-25

User-reported bug fixes

Resolved an issue with handling NUMERIC values less than 0.0001 (#178044)
Resolved an issue with displaying the tooltip for a document bookmark, where the tooltip window overlapped the document bookmark

2025.2.91 23-Oct-25

User-reported bug fixes

Fixed a memory leak when executing queries in the document (#202150)
Added support for the SET ROLE statement (#210470)
Fixed an issue with reading an empty value array when retrieving data from the PostgreSQL server (#212912)

2025.2.37 23-Sep-25

AI Assistant

Introduced automatic error submission from the Error List to AI chat for detailed explanations and suggested fixes
Added a Web Search option in the AI Assistant chat, allowing searches across Devart documentation, website, and blog

Improvements

Improved encryption capabilities
Added tooltips to the SQL document tab, showing connection and database names, document owner, full file path, and server version
Introduced the ability to customize the position where new document tabs open
Added Alt+Up and Alt+Down shortcuts to move selected lines up or down in the SQL document
Added the Ctrl+Shift+A shortcut to select the entire statement in the SQL document, including all related keywords, operators, and values
Introduced the Alias refactoring feature

User-reported bug fixes

Resolved an issue with displaying script differences that occurred when Word Wrap was enabled(#204609)
Added support for NaN values in the numeric data type in Data Editor(#144426)
Fixed an issue with the truncation of numeric values in Data Editor(#178044)
Improved the file opening speed(#146472, #197239 )
Improved document name generation to avoid conflicts with the names of existing open documents(#194908)
Removed the call to pg_backend_pid() between the START TRANSACTION and SET TRANSACTION commands(#198615)
Introduced caret position persistence upon document reload(#188967)

2025.1.230 21-Aug-25

User-reported bug fixes

Fixed time format mismatches between the same data in the view and edit modes (#195613)
Fixed the comparison and synchronization of arrays

2025.1.186 21-Jul-25

User-reported bug fixes

Fixed an issue with the automatic display of Data Editor: when the Activate Data Editor after query execution option is enabled, Data Editor now opens automatically after a query runs, even if no data is returned (#191787, #206510)
Fixed an issue with long file names (#206635)
Removed opening the connection on the main thread when opening the parameter input form
Fixed an issue with the data format for the range of timestamp with time zone type in the synchronization script

2025.1.134 23-Jun-25

User-reported bug fixes

Added support for parsing geometric arrays with schema specification (#198318)

2025.1.124 16-Jun-25

AI Assistant is added

Context-aware query generation
Conversion of natural language to SQL
Query optimization
SQL explanations
SQL troubleshooting
Error analysis and recommendations
AI chat
Integration with the dbForge tools

Connectivity

Added support for PostgreSQL 18

Improvements

Updated color palettes for the Light and Dark skins
Refined font rendering and the coloring of syntax errors
Added Brief View to the Start Page to switch between displaying full paths to recent files and a more compact list

User-reported bug fixes

Fixed an issue where materialized view columns were not displayed in the Database Explorer (#178352)
Fixed the loss of quotes when dragging objects from the Database Explorer into a document (#188973)
Improved query error handling to suppress intrusive message boxes during the initial load and incremental suggestion updates (#199677)
Resolved issues with row selection in SQL Editor (#188972, #199112)
Resolved incorrect parsing of geometry types with dimensions that caused the affected columns to not appear in Database Explorer (#177993, #179971, #202332, #201947)

3.2.126 03-Mar-25

User-reported and internal bug fixes

Resolved an issue where view columns in information_schema were not displaying correctly in Database Explorer on Amazon Redshift (#178352)
Fixed formatting of PostgreSQL data types during export (#155073)
Fixed an error that occurred when using 'plpgsql' in lowercase within an anonymous code block (#188639)
Resolved an issue with editing data in tables containing a SERIAL column in Data Editor (#183485, #184678, #190630)

3.2.47 03-Dec-24

Connectivity

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

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 Compares

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

User-reported and internal bug fixes

Fixed metadata retrieval that could fail on specific server versions (#154740)
Improved support for special values in datetime datatypes (#139021)
Added support for ON UPDATE CASCADE and ON DELETE CASCADE clauses to be applied during the re-creation of foreign keys for data synchronization (#155811, #167879)
Added support for the parsing of the DISTSTYLE keyword in CREATE TABLE statements for Amazon Redshift (#151002)
Fixed an issue with the deletion of words during multi-line selection in the editor (#149219)
Fixed an issue with the parsing of the LIKE ANY construct (#148245)
Fixed an issue with multi-line selection caused by tab characters in the text (#143567)
Fixed an issue with the recovery of a deleted selection when performing an undo operation in the editor (#146741)
Fixed the quoting of case-sensitive column names during the insertion from the completion list (#144980)
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 (#143565)
Added the ability to delete an empty line using the Shift+Delete key combination (#141949)
Fixed the deselection behavior in the text editor shown in a floating window (#146113)
Improved the insertion of date and time data from the clipboard to a cell in Data Editor (#148236)
Improved the export of large volumes of blob data to a file from Data Viewer (#170044)
Fixed repeated password requests for SSH connections (#164049)
Improved error handling behavior when describing objects for code completion (#161730)
Added the ability to display subobjects for DML triggers in Database Explorer (#152468)
Improved the display and calculation of the optimal width of the row number column in Data Editor (#142475)
Fixed the display of data in Data Viewer when double-clicking it in Data Editor (#147103)
Fixed an issue that occurred when deleting a command in an SQL document (#146736)
Fixed an issue that occurred after restoring an SQL document upon opening the Studio (#148363)
Fixed a lag in Data Editor that occurred during the execution of a query against a large table in the paginal mode (#146744)
Fixed the 'canceling statement due to user request' error that occurred during multiple repeated executions of a query in an SQL document (#145274)
Fixed an issue with table names that occurred when generating INSERT commands during data export (#146069)
Fixed an issue with unnecessary quotation marks being added to values when copying data from Data Editor (#146287)
Fixed an issue with the failed selection of the last line in an SQL document (#146340)
Fixed the selection of the current database in the Data Export wizard (#146737)
Added the ability to close a floating window using the Ctrl+F4 key combination (#145259)
Fixed an issue with the 'Execute Current Statement' command that occurred after modifying the query text in an SQL document (#141953)
Fixed a lag that occurred when pointing to a table name in an SQL document (#146110)
Improved the display of the cursor (#145395)
Added diagnostics to determine the cause of errors (#147104)
Added the auto-selection of the column type for suggestions (#141625)
Fixed the behavior of the option 'Activate Data Editor after query execution' (#118496, #130770)
Fixed the issue with incorrect text selection in an SQL document (#146751, #145094, #145398)
Extended the error message displayed in the Error List window with additional information (#141957, #75630)

3.1.839 17-Jan-24

User-reported and internal bug fixes

Fixed an error that occurs when switching between Card View and Grid View in the Data Editor

3.1.832 10-Jan-24

Schema Compare

New Alt + Up/Down Arrow shortcuts for navigating script differences in the lower comparison pane

User-reported and internal bug fixes

Several user reported minor bugs are fixed

3.1.789 27-Nov-23

Improvements

Upgraded from legacy chart designer to advanced new version
Added support for displaying trigger fire on SQL Profiler diagram
Added support for server sequences starting from PostgreSQL server version 9.1
Added support for event triggers in the Generate Script As functionality

User-reported and internal bug fixes

Resolved an issue with column name encoding in scripts generated for Redshift (#130582)
Fixed potential product crash on CrossOver during window animation processing (#134916)
Resolved SELECT query execution error occurring with edit mode activated in Data Editor (#119388, #120119, #120443)
Enhanced syntax checking to include support for the pgvector extension types (#138105, #127261)
Resolved the issue of quote duplication during data copying from Data Editor (#131873)
Fixed error encountered when trying to display the smart tag window (#133770, #138738)

3.1.701 18-Aug-23

User-reported and internal bug fixes

Fixed an error that occurred when parsing the bodies of scripts containing CREATE FUNCTION/PROCEDURE statements

3.1.696 16-Aug-23

Connectivity

Added support for PostgreSQL 16

User-reported and internal bug fixes

Fixed an issue with the quoting of case-sensitive names that occurred during the generation of a synchronization script (#120232)
Fixed an issue that occurred when expanding the Views node in Database Explorer (#123110)
Fixed an issue that occurred when expanding the database list in SQL Document (#127740)
Fixed the incorrect display of fonts that occurred when opening the Studio on Linux or macOS via CrossOver (#118342)
Fixed the incorrect display of the fractional part for the INTERVAL data type (#118190, #118202)
Fixed an issue with the Connection Manager (#123748)
Fixed an issue that occurred when exporting data containing floating-point numbers (#123443, #126756)

3.1.618 24-May-23

Connectivity

Added support for EDB BigAnimal
Added support for TLS 1.3
Added the ability to connect to the database server via SSH using SHA-256/512 algorithms
Added support for Aiven Cloud

Improvements

Optimized the process of retrieving the number of records in a table
Added the ability to save user-defined column layouts in Query History
Added a collection of new code snippets
Added new options for effective tab management
Added support for the UNLOGGED keyword in the CREATE UNLOGGED SEQUENCE command
Improved the behavior of the Disable DML trigger option

User-reported and internal bug fixes

Fixed an error that occurred when using a shared folder on the disk for query cache in Query History (#115047)
Improved the behavior of the Generate Script AS functionality for creating scripts with values as INSERT and UPDATE statements (#117929)
Added alphabetical sorting of triggers in the Database Explorer (#109264)
Fixed an error that occurred when creating an HTML report from the command line (#115292)
Fixed an error that occurred when generating the Quick Info tooltip (#117836)
Added the ability to configure formats for the Boolean data type in the Data Import wizard (#113260)
Fixed an issue with profiling parameterized queries (#118167)
Fixed an issue with processing tables containing columns of PostGIS data types (#115841, #117345, #114863, #113588, #113628, #113826, #114439, #114862)
Fixed the suggestions behavior on databases with foreign tables (#114505)
Fixed an issue with the suggestions generation in SQL editor (#113473)

3.0.472 30-Jan-23

General

Added support for Linux and macOS using CrossOver

Added new Professional Edition, which includes:

Data Compare
Schema Compare
Data Generator
Export of Query History to the CSV format
Command-line support for the following functionality: Data Compare, Schema Compare, Data Generator, Execute Large Scripts, as well as Data Export and Import

Text Editor enhancements

Added support for the SELECT INTO statement
Added suggestions for the names of non-aggregated columns in the GROUP BY clause
Added quick navigation between brackets
Added support for Ctrl+C/X/V hotkeys for coping/cutting entire line in SQL documents
Introduced a triple-click to select the entire line in SQL documents
Added support for RAISE [ NOTICE | WARNING | INFO ] to trace userscript messages in the Error List & Output windows
Added pop-up execution notifications
Added transaction reminders
Added capability to set quotes for identifiers when generating scripts
Added support for Amazon Redshift databases query profiling
Added the auto-refresh of local cache with an option to ignore selected databases

Other

Added support for PostgreSQL 15
Extended support for high-DPI devices
Improved the behavior of the Retrieve Data feature
Added support for AWS Babelfish
Added support for YugabyteDB
Added support for Neon.tech
Added support for Digitalocean Managed Databases
Added support for CitusData
Added support for ApsaraDB
Added support for PolarDB
Added support for AnalyticDB
Added support for Bit.io

User-reported and internal bug fixes

Fixed an error with an incorrect sequence of disabling restrictions that occurred during data synchronization (#48577)
Resolved an issue that occurred when importing data from a OneDrive spreadsheet (#65376, #92269)
Added support for query profiling on older versions of PostgreSQL (T318300)
Fixed an issue that took place while working with the trial version (T323376)
Fixed an error that occurred when connecting to a PostgreSQL database hosted on DigitalOcean (#51449)
Fixed an error that occurred when exporting data that contain accent marks (#72383)
Fixed the retrieval of high-precision floating-point numbers (#74191)
Fixed application freezing that occurred when getting data from a table with a TEXT column (#62033)
Fixed application freezing (#81773)
Fixed an error that occurred when opening the Start Page window (#84519, #84793, #88001)
Fixed an error that occurred on application launch (#93321)
Fixed an error that occurred when retrieving data for a 'scale' table (#85089)
Implemented shortcuts to switch between SQL Document tabs (#104137)
Resolved the Drag & Drop issue in Database Explorer (#99933)
Fixed a bug with the activation of the JSON tab for the JSON and JSONB data types when viewing data in Data Viewer (u33690838)
Fixed an error that occurred when retrieving data from array columns (#94900)
Added the Owner Use field for procedures and functions in the Properties window (#85062)
Fixed an error that occurred when establishing a server connection (#78820, #82508, #95889)
Improved data comparison performance in Data Compare (#77330)
Fixed comparison and synchronization of the RESTRICT, CASCADE, and NO ACTION values for foreign keys in Schema Compare (#74998)
Fixed Data Editor context menu (#68016)
Fixed metadata retrieval for Code Completion (#67261)
Improved Data Editor functionality (#50052)
Substituted the error that occurred when trying to access the pg_shadow schema in Schema Compare without proper rights with a warning (#69369)
Fixed an error that occurred when removing a connection from Database Explorer using the keyboard shortcuts (#67111, #75937)
Fixed an error that occurred when comparing the data types of procedure parameters (#65629)
Fixed the retrieval of database objects on older versions of PostgreSQL (#66474)
Extended the query execution error message with more detailed information (#62014)
Removed extra brackets in the generated view script (#101162)
Fixed an error that occurred when exporting data (#98600)
Fixed an error that occurred when importing data from Excel (#96902)
Fixed an error that occurred when using the DESCRIBE command in Schema Compare (#74998)
Fixed the Ignore Case option in Data Compare (#81596)
Resolved an issue with table columns comparison (#76561)
Added a possibility to make changes to a document connection after deleting a database (#73381)
Fixed an error that occurred when getting DDL of an inherited table
Fixed an error that occurred when opening a SQL document with query profiling results
Fixed the display of query execution time

2.3.287 22-Nov-22

User-reported and internal bug fixes

Fixed PostgreSQL connection issues (#103934, #103042)
Fixed several minor errors

2.3.285 15-Jul-22

User-reported and internal bug fixes

Fixed compatibility issues with the latest Windows 11 updates (#84717,#85016,#90557)

2.3.280 20-May-22

Improvements

Support for scram-sha-256 (#309923)

User-reported and internal bug fixes

Fixed a UI error (#69559, #82938, #85479, #85652)
Fixed an error that occurred when working with the editor in SQL document (#80951)
Fixed an issue with inserting items from a dropdown list (#81792)
Fixed a problem with establishing SSPI connection with the server (#85562)

2.3.278 20-Oct-21

New features

Connectivity support for PostgreSQL 14

User-reported and internal bug fixes

The application fails with a critical error when trying to create diagram objects after installing the KB5006670, KB5006672 or KB5006674 Windows update

2.3.273 12-Aug-21

User-reported and internal bug fixes

Resolved an issue with generating DDL triggers to a script
Resolved an issue with opening a data report document (#62268, #62249)

2.3.268 29-Jul-21

User-reported and internal bug fixes

Fixed an issue that occurred when updating Data Editor with server-side sorting/filtering enabled (#55021)
Fixed an issue that could lead to freezing when executing a function (#59273)
Resolved an issue that led to SQL document losing focus after execution (#55786)
Fixed error report on typing in SQL document (#59275)
Fixed error report on closing SQL Document (#51575)
Resolved an issue with duplicating columns in Member List (#52937)
Fixed incorrect text replacing on inserting items from Member List (#53183)
Fixed false-negative syntax checking (#58703)
Fixed incorrect date format when exporting to Excel (#59970)

2.3.256 11-Mar-21

User-reported and internal bug fixes

The application may fail due to stack overflow error when working with specific queries (#50597, #50612)

2.3.255 25-Feb-21

User-reported and internal bug fixes

The database connection becomes unusable after executing a script with errors (T325239, #48850)
Some parts of the workbook require repairing when exporting data to the Excel 2007 format (T318267)
Possible critical error when trying to display the loading animation image in specific cases (T317898)
The program may fail with a critical error on closing the main window with open documents (T318952)
Possible failures when trying to gather quick info for specific code contexts (T319428)
When trying to generate DDL scripts for tables with previously dropped columns the program faces the fatal error (T324109)
Possible errors when trying to profile queries (T320450)
Incorrect code snippets behavior when composing scripts for creation of functions and procedures (T325785)
Possible failures when preparing data for the completion list (T320422)
In specific cases, the program may fail with the fatal error after opening SQL documents (T320856)
Trying to run specific queries may hang the client session (T324327)
The 'Unicode' option is not enabled by default for new connections (T325045, T325280)
Exporting data to plain text always adds leading whitespaces to the first column (#48683)
The incorrect quotation behavior when exporting to the CSV format (#48683)

2.3.244 28-Dec-20

Improvements

Work of the application when connecting via SSL is improved

User-reported and internal bug fixes

An issue with connecting to IBM Cloud via SSL (T303131, T320717, T319699)
An issue with processing Quick Info hints (T319058, T319156, T319659, T319691, T319693, T319988, T320235, T321077, T321261, T321490, T321776, T321918, T322315, T322671, T322705, T321466)
Error with data export from multiple tables (T321285)
Error with displaying data in FK LookUp editor (T320949)
Error with editing data when pressing Space (T317850)
The discrepancy between column type and data editor in it (T317850)
Treatment of the "REINDEX" keyword as an unexpected symbol (T318951)
An option to append a timestamp to a file name is enabled by default (T318267)
Error with closing SQL document (T320205, T321175)
Error with retrieving data from the compound types based on other compound types (T321077)
Displaying datatype in the header of Data Editor (T322960)

2.3.237 21-Sep-20

User-reported and internal bug fixes

The application could fail with a critical error when restoring documents from previous sessions (T316768, T317636)
An error occurred when trying to view indexes for the columns not available in the database explorer (T316956)
Incorrect scripts were generated for dropping functions (T316947)
The execution process for invalid scripts could hang (T317509)
The application could fail with a critical error when trying to display the quick info (T316765)
It was impossible to set the TIMESTAMP value to the current date and time Data Editor (T317507)
An error could occur during snippets storage initialization
A critical error could occur when launching Query Profiler

2.3.230 31-Aug-20

User-reported and internal bug fixes

The application failed with a critical error when pressing Backspace immediately after completing a table name (T315942)
An error occurred while exporting documents or data to '*.docx' format due to missing assembly (T315012)
Possible fatal error on filtering a completion list (T316045)
An error that could occur while filling table columns in a completion list (T316070)
The 'DROP OPERATOR' statement was treated as invalid syntax construction
Possible failure with a critical error when editing multi-line select script with opened completion list
The 'IF NOT EXIST' option was treated as invalid syntax when typed after 'ADD COLUMN' clause
The '[ AND [ NO ] CHAIN ]' options were treated as invalid for the 'ROLLBACK' statement

2.3.212 12-Aug-20

Script Generator Improvements

Generate Script as DROP and CREATE SEQUENCE
Generate Script as DROP and CREATE TABLE
Generate Script as DROP and CREATE for all Source Objects
Generate Script as CREATE INDEX

SQL Formatter Improvements

CREATE TRIGGER
CREATE INDEX
CREATE SEQUENCE
CREATE TABLE
CREATE VIEW
CREATE MATERIALIZED VIEW
CREATE PROCEDURE\FUNCTION

Query Profiler Improvements

Option to view query execution plan without running a query was added

User-reported and internal bug fixes

Fatal error caused by the absence of the 'Bezier' skin in the application preferences and which occurred when trying to save options when the skin was active (T293202, T302581, T304084)
Treatment of the "ILIKE" keyword as an unexpected symbol (T305684)
Incorrect formatting for TIMESTAMP values was fixed (T298357)
Critical error occurred when trying to paste empty values to integer fields (T308920)
The 'syntax error at or near ")"' error message displayed in specific cases when working with indexes (T309366)
Issue with possibly incorrect quotation handling leading to errors during syntax check and formatting (T308442)
Critical error occurred due to incorrect command availability handing when trying to copy from query results grid with row numbering enabled (T309718)
Possible unexpected server response errors (T311429, T306785, T312252)
Errors that might occur when formatting expressions from executable code fragments (T308582, T313109)
Possible errors when parsing complex scripts (T310955)
Critical error occurred when processing extremely large scripts containing the '$$' sequence
Critical error the application faced after closing the document in case its text has not been yet supplied

2.2.207 05-Dec-19

User reported bugs fixed

Problem with edit parameter window is fixed (T298233)
Problem with data import through Devart ODBC driver for Oracle is fixed (T298292)
Queries executing with custom parameters issue is fixed (T297883)
Problem with query profiling on 4K display is fixed (T297789)
Problems with data selecting from big tables are fixed (T297618, T297610)

2.2.198 12-Nov-19

User reported bugs fixed

Problem with Query Profiling Mode on High Definition displays is fixed (T297789)

2.2.197 07-Nov-19

User reported bugs fixed

Problem with query running when Query Profiling Mode is turned on is fixed (T293197)
Problem with aliases generating is fixed (T296186)
Problem with foreign key lookup when editing cell in data editor is fixed (T293995)
Problem with query parameters in sql document is fixed (T293611)
Problem with sql formatting when NOT EXISTS clause using is fixed (T293445)

2.2.184 01-Oct-19

New features

Connectivity support for PostgreSQL 12
Support for Amazon RedShift
Generate Script AS CREATE for Source Objects
SQL Code Formatter
Cached Update mode in Data Eidtor
Dramatically improved performance of Large Script Execution
New modern application skins

User reported bugs fixed

Problems with option Query Profiling Mode are fixed (T282537, T291096)
Problem with data view in data editor is fixed (T291144)
Problems with connectinig to server are fixed (T289975, T289283)
Problem with comments in script is fixed (T281868)
Problem with incorrect data in Quick Info is fixed (T284615)
Other user reported bugs are fixed (T282483, T262814, T293121)

2.1.97 06-May-19

New features

Connectivity Support for Greenplum DB
Query Profiler functionality

Improved features

Code Completion
Database Explorer
Execute Large Script wizard

User reported bugs fixed

Problem with connection to database is fixed (T273168)
Problem with highlighting keywords is fixed (T272218)
Problem with supporting unicode characters is fixed (T276532)
Problem with data importing from Excel is fixed (T274766)
Problem with editing connection category is fixed (T272243)
Problem with displaying databases is fixed (T252288)
Other user reported bugs are fixed (T247464, T271986, T271985, T277736)

2.0.111 10-Dec-2018

New features

Data Export&Import Wizard
Executed SQL Statements History
Execute Large Script Wizard
Master-Detail Browser
Pivot Table
SQL Snippets
Data Reports

SQL Document

Context prompt in the FROM list of the SELECT queries
Full code completion support for the SELECT statement

Connectivity

SSH connection
Connectivity support for PostgreSQL 11.x
Connectivity support for PostgreSQL 10.x
Connectivity support for PostgreSQL 8.3, 8.2, 8.1
Connectivity support for elephantsql.com

Other Improvements

Digital signature for the installation file
FIPS compliance
The Express Edition will be activated after Standard Edition trial expires

User reported bugs fixed

Empty field in "Find Result" issue is fixed (T262783)
Problems with object names in double quotes are fixed (T254981, T254663, T261473)
Ignore capitalization of tables issue is fixed (T252294)
Wrong navigation in "Find Results" issue is fixed (T262783)
Data editing after refresh issue is fixed (T249168)
Problem with look up using Foreign Key in data grid is fixed (T249168)
Wrong error output into "Error List" window issue is fixed (T267239)
Other user reported bugs are fixed (T265265, T262783, T262107, T266337, T246559, T248389, T247982, T249168, T249748, T257319, T256988, T257328, T257784, T257498, T258069, T252101, T248339, T252633, T258491, T244493)

1.0.410 05-Jun-2018

User reported bugs fixed

Problem with connection to PostgreSQL 10.4 is fixed (T258409)
Menu item "Retrieve Data" issues are fixed (T255318, T255332, T255583, T256624)
Problems with double click on a table in the database explorer tree are fixed (T255320, T255441, T255472, T255529, T255572, T255684, T255753, T256393, T256652, T257694, T257665, T257778, T257774, T257825, T257894, T258400, T258674, T258694, T258671)
Problem with expanding some index in the database explorer tree is fixed (T255319)
Null Reference Exception issue is fixed (T249168)
Problem with jsonb value is fixed (T249168)

1.0.381 24-Apr-2018

User reported bugs fixed

Wrong page after successfully installation issue is fixed (T254732)
Problems with database name are fixed (T254663, T254981)
Column value editing issue is fixed (T249168)
Execute script issue is fixed (T253087)
Problems with catalogs, temporary schemas and tables display are fixed (T251539, T247102)
Problem with incorrect format is fixed (T246966)

1.0.344 03-Mar-2018

First release of dbForge Studio for PostgreSQL