When comparing DbForge Studio for PostgreSQL vs DBeaver, the Slant community recommends DBeaver for most people. In the question“What are the best database design programs?” DBeaver is ranked 1st while DbForge Studio for PostgreSQL is ranked 12th. The most important reason people chose DBeaver is:
Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86).
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Advanced code completion features
Prompting the names of existing materialized views, as well as context prompting of database objects
Pro Query Profiler
Helpful diagrams of query execution, and also the list of operations that takes place on the server
Pro Data Editor
The data can be edited in the same way as with Google Sheets/MS Excel or in the card view mode.
Pro High execution speed
Downloading the main_ExceptionFrames.sql file of 100 Mb in size ~ 1 min
Pro SQL Code Formatter
Automatic formatting of SQL Code based on user-chosen code styles
Pro Data Export/Import
10+ file format support, including Google Sheets
Pro Master-Detail Browser
The 'design view' for setting up relations between tables, smart sorting, and filtering
Pro Code complition
Prompting keywords for functions etc.
Pro Cached update mode in Data Editor
Allows to control data editing within database objects
Pro Generate Script AS feature
Allows generating a script for the CREATE statements for specific database objects (views, materialized views, triggers, functions, procedures)
Pro Object Explorer
Provides a quick navigation through the object tree
Pro File format support
Dozen of file formats are supported, including Google sheets.
Pro Cross-platform
Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86).
Pro Free
It is licensed under GPL v2.
Pro Works for many types of databases
MySQL, Oracle, PostgreSQL, IBM DB2, Microsoft SQL Server, Microsoft Access, Sybase, Java DB (Derby), Firebird (Interbase), Derby (JavaDB), SQLite, Mimer, HSQLDB, H2, IBM Informix, Teradata, SAP MAX DB, Cache, Ingres, Linter, Vertica, MongoDB, Cassandra, ODBC, Any JDBC compliant data source.
Pro Follow foreign key to their primary key
If you have a table with a foreign key you can click on it to see the table row where this key references to.
Pro Formatted text view
It has the classic grid view and a well-organized text view that you can quick-select with CTRL-A.
Pro Easy to use, clean neat inteface
Cons
Con Data export
Data export does an individual insert per row of data, which is a little inefficient.
Con Never-ending function errors
Like, 'Communications link failure', 'Connection refused' (Community Edition 6.2.1).
Con Cannot view function
Con Trigger edition
Until version 3.5.8 you can not edit triggers, only view (since 3.5.6).