Ecosystem:dbForge Studio for PostgreSQL

From PostgreSQL wiki
Jump to: navigation, search

dbForge Studio for PostgreSQL is a graphical user interface client and all-in-one tool for developing and administering PostgreSQL databases. Using this PostgreSQL integrated development environment (IDE), users may write, develop, and run queries, as well as update and modify the code to match their individual requirements, all in an intuitive interface. This package for PostgreSQL includes features such as data reporting and alteration, data import and export, as well as the creation of pivot tables and tailoring relationships, among other features.

SQL Development

Improve the code quality while developing and modifying queries with such features:

  • PostgreSQL Code Completion
  • SQL Code Formatting
  • SQL Syntax Check

Database Explorer

Explore the PostgreSQL object tree until you find the PostgreSQL item you're looking for. Right-click the relevant object in the Database Explorer window to carry out these tasks:

  • Using a single SQL document, extract data from the database
  • Truncate a table
  • Get the information on the object from Properties
  • Create Script AS

Data Export and Data Import

Tools for feeding a database with data from outside sources and transferring data between systems. More than 10 regularly used data types are supported by dbForge Studio for PostgreSQL, as well as a variety of adjustable parameters and templates for frequently occurring cases.

  • More than ten different file types are supported
  • Customizable data import and export options
  • Useful data export and import wizards
  • PostgreSQL data transfer

Query Profiler

This efficient query analyzer helps you find bottlenecks and optimize slow SQL queries. The profiling findings are organized logically across multiple tabs, with each tab presenting the following profiling information:

  • Plan Tree of query execution
  • The cost of all operations as a percentage of the total batch cost is depicted in a query processing diagram
  • A list of the most important server operations

Data Reports and Analysis

dbForge Studio for PostgreSQL has a lot of features for aggregating and sorting data, as well as providing professional and convenient visual reports, so you can identify and analyze the data.

  • Data Report Wizard
  • Report Designer
  • Pivot Tables
  • Chart Designer.

Note that the minimum requirements include .NET Framework 4.5.2 or higher installed.

History

The 1.0.410 version was released on June 05, 2018.

The 2.0 version with Brand New Standard Edition was released on December 10, 2018.

The 2.1 version with a new query optimization feature, Greenplum DB connectivity was released on May 06, 2019.

The 2.2 version with SQL Code Formatter, a new 'Generate Script AS' feature, Cached Updates Mode in Data Editor, and a bunch of other notable improvements was released on October 01, 2019.

The latest version 2.3 contains improved Script Generator, SQL Formatter, Query Profiler functionality, and was released on August, 12, 2020. For a list of changes see the revision history.

Learn more

Also, the product includes a free 30-day trial, you can download it here.

To learn more information about dbForge Studio for PostgreSQL, please visit this page.