Postico 1.3.3 – A modern PostgreSQL client.

April 8, 2018

Postico provides an easy to use interface, making Postgres more accessible for newcomers and specialists alike. Postico will look familiar to anyone who has used a Mac before. Just connect to a database and begin working with tables and views. Start with the basics and learn about advanced features of PostgreSQL as you go along. Postico is an intuitive app for looking at data. Filter rows, sort them, rearrange columns. You can examine long text or images conveniently in the sidebar. Even related rows from referenced tables are shown. Edit rows directly, or use the sidebar, a great choice for long text. You can even change multiple rows at once. Batch saving (with SQL preview) lets you commit changes to multiple rows in a single transaction. Postico sports a query view inspired by Sequel Pro, the popular MySQL client. But with sophisticated features like multiple query results, Postico goes even beyond its role model.

What’s New

Version 1.3.3:

Improvements:

If multiple completions are possible they are shown right away
typing a literal tab character is now possible after using tab completion / autocomplete
Pressing alt-tab now always inserts a literal tab
Fixed placement of the autocomplete window when the cursor is near the edge of the screen
Don't trigger autocomplete when pressing cmd-period
Added support for late binding views on Amazon Redshift
Fixed an autolayout bug on macOS 10.10 in the preferences window
2.75x faster SQL parsing
You can now paste URLs into the favorites window
Postico now ignores whitespace when parsing URLs
It's no longer required to include user name & database name when opening URLs if you already have a matching favorite.
You can use the scheme postico instead of postgresql if you want to open Postico specificallyBetter
Postico now ensures that other apps cannot use its SSH Tunnel
The text editor now has improved word boundary detection when using schema qualified identifiers (eg. when using option + arrow key)
Support for LISTEN / NOTIFY
Support for using three finger swipe gestures to go back / forward (when enabled in system preferences)
Fixed a crash when using the context menu in the sidebar
Fixed incorrect tab width in SQL text view that occurred with some fonts (eg. Monaco)
Fixed an issue where SQL text fields "captured" the tab key
Don't abort editing text fields when pressing cmd-period or F5
Pressing Esc when editing filters no longer removes the filter (it just cancels editing instead)
Cycling through foreign key fields in the sidebar now works

Notifications:

Clicking a "Query Done" notification now shows the query that was completed. Also, Postico no longer creates notifications when the query is in the foreground