Postgresql cmd

# instructio of first using postger


# OPEN CLI AS ROOT
sudo -u postgres psql
#command above open cli as super admin 

#CREATE USER
sudo -u postgres createuser <username>

#CREATE DATABSAE
sudo -u postgres createdb <dbname>

/**
*
*
*/

/**
*AFTER OPEN POSTGER CLI 
*/

#GIVE THE USER PASSWORD
alter user <username> with encrypted password '<password>';

#GRANT PREVELIGA OF DATABASE TO USER
grant all privileges on database <dbname> to <username> ;