Devart dbForge Studio for PostgreSQL Professional Edition v3.0.472
Devart dbForge Studio for PostgreSQL Professional Edition v3.0.472
dbForge Studio for PostgreSQL is a GUI tool for database development and management. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to their requirements in a convenient and user-friendly interface.
The tool also provides functionality for PostgreSQL data reporting, data editing, data import and export, building pivot tables and master-detail relations.
SQL Development
Save your time and improve code quality when creating and editing queries with the following features:
List Members
Parameter Info
Quick Info
Complete Word
SQL Code Formatter
Database Explorer
Navigate through the object tree and find any PostgreSQL object you are interested in. Right-click the required object in the Database Explorer window to perform the following tasks:
Retrieve data from the database on a single SQL document
Truncate a table
Select Properties to view information on the object
Generate Script AS
Data Editor
Editing table data becomes a simple task with dbForge Studio for PostgreSQL. You can manage settings of tables, such as adjust column width, set either paginal or auto-search mode by default. Color and format your rows and cells using a rich set of fonts and size. Additionally, the tool provides you with predefined data type formats so that you can select the most suitable for your needs.
Working with data can be more productive with the help of:
In-place data editing
Look-up data editing
Cached Updates Mode data editing
Table, Text, Card Views
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 connectivity support for PostgreSQL 15
Extended support for high-DPI devices
Improved the behavior of the Retrieve Data feature
Added connectivity support for AWS Babelfish
Added connectivity support for YugabyteDB
Added connectivity support for Neon.tech
Added connectivity support for Digitalocean Managed Databases
Added connectivity support for CitusData
Added connectivity support for ApsaraDB
Added connectivity support for PolarDB
Added connectivity support for AnalyticDB
Added connectivity 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 (D48577)
Resolved an issue that occurred when importing data from a OneDrive spreadsheet (D65376, D92269)
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 (D51449)
Fixed an error that occurred when exporting data that contain accent marks (D72383)
Fixed the retrieval of high-precision floating-point numbers (D74191)
Fixed application freezing that occurred when getting data from a table with a TEXT column (D62033)
Fixed application freezing (D81773)
Fixed an error that occurred when opening the Start Page window (D84519, D84793, D88001)
Fixed an error that occurred on application launch (D93321)
Fixed an error that occurred when retrieving data for a 'scale' table (D85089)
Implemented shortcuts to switch between SQL Document tabs (D104137)
Resolved the Drag & Drop issue in Database Explorer (D99933)
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 (D94900)
Added the Owner Use field for procedures and functions in the Properties window (D85062)
Fixed an error that occurred when establishing a server connection (D78820, D82508, D95889)
Improved data comparison performance in Data Compare (D77330)
Fixed comparison and synchronization of the RESTRICT, CASCADE, and NO ACTION values for foreign keys in Schema Compare (D74998)
Fixed Data Editor context menu (D68016)
Fixed metadata retrieval for Code Completion (D67261)
Improved Data Editor functionality (D50052)
Substituted the error that occurred when trying to access the pg_shadow schema in Schema Compare without proper rights with a warning (D69369)
Fixed an error that occurred when removing a connection from Database Explorer using the keyboard shortcuts (D67111, D75937)
Fixed an error that occurred when comparing the data types of procedure parameters (D65629)
Fixed the retrieval of database objects on older versions of PostgreSQL (D66474)
Extended the query execution error message with more detailed information (D62014)
Removed extra brackets in the generated view script (D101162)
Fixed an error that occurred when exporting data (D98600)
Fixed an error that occurred when importing data from Excel (D96902)
Fixed an error that occurred when using the DESCRIBE command in Schema Compare (D74998)
Fixed the Ignore Case option in Data Compare (D81596)
Resolved an issue with table columns comparison (D76561)
Added a possibility to make changes to a document connection after deleting a database (D73381)
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
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 connectivity support for PostgreSQL 15
Extended support for high-DPI devices
Improved the behavior of the Retrieve Data feature
Added connectivity support for AWS Babelfish
Added connectivity support for YugabyteDB
Added connectivity support for Neon.tech
Added connectivity support for Digitalocean Managed Databases
Added connectivity support for CitusData
Added connectivity support for ApsaraDB
Added connectivity support for PolarDB
Added connectivity support for AnalyticDB
Added connectivity 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 (D48577)
Resolved an issue that occurred when importing data from a OneDrive spreadsheet (D65376, D92269)
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 (D51449)
Fixed an error that occurred when exporting data that contain accent marks (D72383)
Fixed the retrieval of high-precision floating-point numbers (D74191)
Fixed application freezing that occurred when getting data from a table with a TEXT column (D62033)
Fixed application freezing (D81773)
Fixed an error that occurred when opening the Start Page window (D84519, D84793, D88001)
Fixed an error that occurred on application launch (D93321)
Fixed an error that occurred when retrieving data for a 'scale' table (D85089)
Implemented shortcuts to switch between SQL Document tabs (D104137)
Resolved the Drag & Drop issue in Database Explorer (D99933)
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 (D94900)
Added the Owner Use field for procedures and functions in the Properties window (D85062)
Fixed an error that occurred when establishing a server connection (D78820, D82508, D95889)
Improved data comparison performance in Data Compare (D77330)
Fixed comparison and synchronization of the RESTRICT, CASCADE, and NO ACTION values for foreign keys in Schema Compare (D74998)
Fixed Data Editor context menu (D68016)
Fixed metadata retrieval for Code Completion (D67261)
Improved Data Editor functionality (D50052)
Substituted the error that occurred when trying to access the pg_shadow schema in Schema Compare without proper rights with a warning (D69369)
Fixed an error that occurred when removing a connection from Database Explorer using the keyboard shortcuts (D67111, D75937)
Fixed an error that occurred when comparing the data types of procedure parameters (D65629)
Fixed the retrieval of database objects on older versions of PostgreSQL (D66474)
Extended the query execution error message with more detailed information (D62014)
Removed extra brackets in the generated view script (D101162)
Fixed an error that occurred when exporting data (D98600)
Fixed an error that occurred when importing data from Excel (D96902)
Fixed an error that occurred when using the DESCRIBE command in Schema Compare (D74998)
Fixed the Ignore Case option in Data Compare (D81596)
Resolved an issue with table columns comparison (D76561)
Added a possibility to make changes to a document connection after deleting a database (D73381)
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
Only for V.I.P
Warning! You are not allowed to view this text.