When comparing DbVisualizer vs SQL Workbench/J, the Slant community recommends DbVisualizer for most people. In the question“What are the best GUI tools for PostgreSQL on Windows?” DbVisualizer is ranked 8th while SQL Workbench/J is ranked 12th. The most important reason people chose DbVisualizer is:
This is a good and stable tool with really good and useful functionality: import/export, SSH tunnelling, fast searching, duplication, DDL visualization etc. If you are a professional, don't complain about the pricing. If you're an amateur, maybe this isn't for you.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Professional tool
This is a good and stable tool with really good and useful functionality: import/export, SSH tunnelling, fast searching, duplication, DDL visualization etc. If you are a professional, don't complain about the pricing. If you're an amateur, maybe this isn't for you.
Pro Duplicate row button
Makes it really easy to stub out example data while developing, just change the values with unique constraints and you have extra data ready to go.
Pro Wildcard finder
Has a search box that will highlight any matching row, regardless of what field is matched (spans multiple columns).
Pro In-line editing
Allows you to edit and save db rows through a spread-sheet like editor.
Pro Allows you to edit changes before they are executed.
Any changes to the database generate SQL statements that you can review and edit before running.
Pro Works with almost any SQL database
Can work with any database with a jdbc driver.
Pro Can edit data in table mode.
Easy to make changes when viewing data.
Cons
Con Expensive
License for the full product is costly.