Learn how to use pgAdmin, the graphical user interface (GUI) client for PostgreSQL. Create tables for messages and users.
Learn about the PSQL tool. It's a command line to make PostgreSQL queries.
Learn about the Query tool. It's the graphical equivalent of PSQL.
Learn how to create a user/role. Then create a database.
Then learn to create tables, navigate pgAdmin through its various functions to help you in performing SQL queries through a user interface.
You learn that clicks in pgAdmin actually translate to executing a SQL command behind the scenes.
Source Code: https://github.com/nbktechworld/full-...