Postico For Mac

PostgreSQL is one of the most powerful and comprehensive database management systems out there, therefore working with it is not as easy as it may seem.

Postico is a streamlined and efficient PostgreSQL database manager that aims to make working with Postgres to be as simple as possible via an intuitive native OS X interface.

As is the case with many application of this kind, PostgreSQL’s user interface is quite straightforward: a top toolbar, a preview and editing panel in the middle of its main window, and a bottom toolbar. Featuring a patched version of Libpq 9.3.4, Postico can connect to servers that use PostgreSQL 8.0, 8.4, 9.1, 9.2, 9.3, 9.4, and Amazon Redshift.

Once you have connected to a local PostgreSQL database, you can easily filter rows, sort them, rearrange columns, examine long text or images in the sidebar, and edit rows, as well as change multiple rows.

Postico enables you to add and remove, change their types, and to modify tables so that you can be sure your database’s structure is as you want it. As far as data analysis is concerned, Postico makes this possible with the help of common table expressions, recursive queries, filter aggregates, and window functions.

As added benefits, Postico comes with support for both SSL and SSH encryption systems and keeps all your passwords stored safely in the keychain system.

Taking all things into consideration, Postico is a dependable and efficient database manager that, in many respects, manages to make the work with PostgreSQL a little more comfortable for both beginner and experienced users alike.