Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to SafariWhen comparing Postico vs SQLGate, the Slant community recommends SQLGate for most people. In the question“What are the best GUI tools for PostgreSQL on Windows?” SQLGate is ranked 9th while Postico is ranked 10th. The most important reason people chose SQLGate is:
Functions; filter, sort and group on grid / Copy, past, sum and statistics functions like excel.
Specs
Question Ranking
Pros
![[deleted]](https://avatars.slant.co/identicons/50/01aa8b5b-42bc-570f-8f6d-1c48ea34388e)
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 Quick data analysis
Functions; filter, sort and group on grid / Copy, past, sum and statistics functions like excel.
Pro Saves time with autocomplete & template functions
Pro Fast processing and easy customization
They put out weekly updates, so there are new and impressive functions being added pretty consistently.
Pro Supports cloud-based DB such as AWS & Azure
Pro Includes PL/SQL editor and debugger
Pro ER diagrams
Entity Relationship database diagrams limitations are: only supports reverse engineering, and can not export to formats other than .erd
Cons
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.
Con Commercial
Postico is a commercial app, with a one-time fee of $35. There is a free trial available.
Con Logon
The logon process after starting up the application is rather long winded (tested with PostgreSQL, no defaults shown for e.g. port number).
Con Free version is limited
e.g. only 10 tables allowed in ERD designer.
