pgcli vs Postico: What are the differences?
Developers describe pgcli as "Postgres CLI with autocompletion and syntax highlighting". This is a postgres client that does auto-completion and syntax highlighting. On the other hand, Postico is detailed as "A modern PostgreSQL client for OS X". 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.
pgcli and Postico can be categorized as "Database" tools.
Some of the features offered by pgcli are:
- Auto-completion as you type for SQL keywords as well as tables and columns in the database.
- Syntax highlighting using Pygments.
- Smart-completion (enabled by default) will suggest context-sensitive completion.
On the other hand, Postico provides the following key features:
- Peek inside your database. Then edit as needed.
- Design a database with a sound structure.
- Query, Enquire, Investigate.
pgcli is an open source tool with 8.01K GitHub stars and 365 GitHub forks. Here's a link to pgcli's open source repository on GitHub.