When comparing Navicat for PostgreSQL vs QueryPie, the Slant community recommends Navicat for PostgreSQL for most people. In the question“What are the best GUI tools for PostgreSQL on Windows?” Navicat for PostgreSQL is ranked 3rd while QueryPie is ranked 7th. The most important reason people chose Navicat for PostgreSQL is:
The Navicat UI is extremely quick to respond to requests.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Fast UI
The Navicat UI is extremely quick to respond to requests.
Pro Good autocomplete
Navicat offers a strong code completion feature.
Pro Saves queries by name
Pro Very stable
Pro Clean and pretty UI/UX
The default color is dark and comfortable for the eyes.
Pro Multiple Query Tabs!
The multi-tab and multi-SQL-runs are great. It's always good to be able to compare results in one window instead of having to go through and re-run stuff.
Pro Fast Auto-complete
Pro Multiple Databases
They only support 2 at the moment (MySQL and MariaDB) but their social site says they'll be updating with more DBMSes in the near future which is pretty nice because I hate learning new GUIs~
Pro Cross-Platform
Not sure about Linux but it works on Windows and Mac just fine!
Pro Free!
Cons
Con Expensive
Navicat is quite expensive at $149 for the standard edition, and $199 for enterprise.
Con Requires creating an account
Requiring an account is rare on SQL IDEs...