PostgreSQL Installation & Setup

Install

sudo apt install postgresql postgresql-contrib
sudo -u postgres createuser --interactive
sudo -u postgres createdb mydb

Connect

sudo -u postgres psql
\l          -- List databases
\c mydb     -- Connect to db
\dt         -- List tables