Postgresql is an open-source SQL database.

Basic commands

Enter the Postgres user: sudo su - postgres -c 'psql'

\dtlist tables \llist databases \c <db-name>switch to a database

You can update the default password of the default user as shown: ALTER USER postgres PASSWORD ‘new_secure_password’;