When comparing Postico vs QueryPie, the Slant community recommends QueryPie for most people. In the question“What are the best GUI tools for PostgreSQL on Windows?” QueryPie is ranked 7th while Postico is ranked 10th.
Ranked in these QuestionsQuestion Ranking
Pro Native experience and clean user interface
Postico is a native OS X app which is available through Mac App Store. The UI is fast, responsive and integrates seamlessly with the OS.
Pro Created by an experienced developer in the field
Postico is the successor of PG Commander, an older Mac Posgres GUI tool which is also widely used. They are both maintained by the same person.
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 Clean and pretty UI/UX
The default color is dark and comfortable for the eyes.
Not sure about Linux but it works on Windows and Mac just fine!
Con No multiple query tabs in the free trial version
To be fair, multiple windows / tabs IS a feature. It's just part of the paid version.
Postico is a commercial app, with a one-time fee of $35. There is a free trial available.