When comparing SQLTools for VS Code vs Postico, the Slant community recommends Postico for most people. In the question“What are the best Mac OS X GUIs for PostgreSQL?” Postico is ranked 6th while SQLTools for VS Code is ranked 13th. The most important reason people chose Postico is:
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.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Integrates with VS Code
Integration with VS Code allows a developer to go from writing code to making DB changes without ever leaving their favorite editor
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.
Cons
Con Integrates with VS Code
This is not a desktop native application. It will just take VS Code and add YET ANOTHER tool to the tool bar, which can get very cluttered very fast
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.