Some users still prefer CLIs for interaction with PostgreSQL databases, particularly in the production environment. While you can use all the powerful capabilities of PostgreSQL through 'raw' queries alone, using a PostgreSQL editor can create a more user-friendly experience that requires less in-depth knowledge of PostgreSQL. For example, you need to be an advanced user to optimally display table columns in an easy-to-read manner like the example above.
However, that approach can be inconvenient because: Traditionally you'd use the psql command-line interface (CLI) to create, update, query, and delete data from PostgreSQL or to manage the database.
Without some form of editor or graphical user interface (GUI), the default means of interacting with PostgreSQL is through running SQL queries. PostgreSQL, also known as Postgres, is the most popular and advanced enterprise-grade open-source relational database software.