PostgreSQL (also called Postgres) is an advanced and powerful Object-Relational database management system (DBMS), with a strong reputation on enterprise environment, designed for scalability, performance, high availability, reliability and feature robustness. It supports a large part of the SQL standard and offers many modern features:
psql is a CLI client for Postgres administration, psql allows:
– Connect to the server
– Create DB
– Admin users
– Execute SQL queries and perform administration tasks in general.