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.
New Feature: Autocomplete
Postico now has a brand new autocomplete feature for the SQL query editor.
Press Esc or Ctrl-Space to show a list of possible completions. Postico shows completions for SQL keywords, table names, column names and functions.
Press Tab to automatically complete words. Tab completion works very similar to command line tools like psql and bash.
Bugfixes and Improvements
the “Does Not Contain” filter now includes NULL values
the “Is Distinct From” filter now works on Amazon Redshift
Postico now correctly detects Microsoft Office documents in bytea columns
The text field in the DROP DATABASE dialog is now focussed initially
Fixed a bug that caused text to disappear when clicking the “view definition” field on macOS High Sierra