Postico is a modern application for your Mac.
Postico is the perfect tool for data entry, analytics and application development.
– connect to Postgres.app
– connect to PostgreSQL 8.0, 8.1, 8.2, 8.4, 9.0, 9.1, 9.2, 9.3, 9.4, 9.5 and 9.6 servers
– connect to cloud services such as Heroku Postgres, Amazon Redshift, Amazon RDS
– connect to other RDBMs that use the PostgreSQL protocol, for example, CockroachDB
Postico is the perfect application for managing your data. He has excellent data entry tools. Filter the lines containing the search term, or set up advanced filters with several conditions. Quickly browse rows from related tables and save time by editing multiple rows at once.
For analytical workloads, Postico has a powerful query editor with syntax highlighting and many advanced text editing features. Run multiple queries at the same time or execute them one at a time and quickly export the results.
For application developers, Postico offers a full-featured spreadsheet designer. Add, rename and delete columns, set default values and add column constraints (NOT NULL, UNIQUE, CHECK constraints, foreign keys, etc.). Document your database by adding comments to each table, view, column, and constraint.
But the best part of Postico is how well it works. Postico made on Mac for Mac. It works great with all other Mac applications. Use all the usual keyboard shortcuts. Postico gets basic functions such as copy / paste, and also supports more complex functions, such as text editing services.