Description

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

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 to search the web, including Devart documentation, the website, and the 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)

Additional Information