dbForge Studio for PostgreSQL 3.1.839

dbForge Studio for PostgreSQL Enterprise is a GUI client and popular tool for managing and developing PostgreSQL databases. This PostgreSQL IDE allows users to create, develop and execute queries, edit and adapt code according to their requirements in a convenient and user-friendly interface.

Main features:

SQL Development

• Save your time and improve code quality when creating and editing queries with the following features
• PostgreSQL code completion
• Code format
• SQL Check SQL syntax

Database Explorer

• Navigate through the object tree and find any PostgreSQL objects that interest you. Right-click the required object in the Database Explorer window to perform the following tasks
• Retrieve data from a database on an SQL document
• Truncate a table
• Select Properties to view information about the object
• Create AS Script

Export data and import data

• Important tools for populating databases with external source data and moving data between systems. dbForge Studio for PostgreSQL supports more than 10 widely used data formats, several advanced options, and templates for recurring situations.
• Over 10 file formats supported, including Google Sheets
• Flexible data import and export customization
• Handy wizard for exporting and importing PostgreSQL data migration

Query Analyzer

• This intuitive PostgreSQL query analyzer helps identify bottlenecks and tune the performance of slow SQL queries. The profiling results are neatly displayed in several tabs, providing the following profiling data
• Query Execution Tree Plan
• Query execution diagram with cost of all operations as percentage of total batch cost
• List of top activities taking place on the server
• Execution plan in XML format