Iterm. Homebrew. Postico – a modern PostgreSQL client for the Mac. Postico requires macOS 10.10 or later. Version 1.5.6 was released on Mar 18, 2019. Read the Changelist. Also available on the Mac App Store. We also offer Legacy Downloads for older versions of macOS. Postico is under active development. Leave your email adress and I'll tell you about new features as soon as they're ready. PostgreSQL is an absurdly powerful database, but there's no reason why using it should require an advanced degree in relational theory.
Postico will look familiar to anyone who has used a Mac before. Postico is an intuitive app for looking at data. Edit rows directly, or use the sidebar — a great choice for long text. Add and remove columns, rename them, change types. The unified structure editor displays everything you need to know about a table. When you need hard questions answered, PostgreSQL offers many advanced tools for data analysis: Common table expressions, recursive queries, filter aggregates, window functions. Which versions of PostgreSQL are supported?