Database Setup
sudo -u postgres psqlCreate Database and User
CREATE DATABASE code_monitor;
CREATE USER codemonitor WITH PASSWORD 'admin@123';
GRANT ALL PRIVILEGES ON DATABASE code_monitor TO codemonitor;User Management
CREATE USER admin WITH PASSWORD 'admin';
ALTER USER admin WITH SUPERUSER;Show Databases
\lConnect to a Specific Database
\c your_database_nameShow Tables in the Current Database
\dtExport Database
sudo -u postgres pg_dump -U postgres code_monitor > dbexport.pgsql