Introduction

Have you ever used the Postgres database and did you know you don’t have to launch PGAdmin every time you want to write SQL queries, you can write down those queries even inside a terminal with a python package. It’s PGCLI, that can act as an editor window for writing SQL queries for Postgres Databases. We can simply execute SQL queries in a PSQL-like shell with additional features like autocompletion, text-editing modes, file input/output options, etc.