Commands


  - list database
  \l
  
  - Create database 
  create database blog;

  - Create user
  CREATE USER blogadmin WITH ENCRYPTED PASSWORD 'passwrd';
  ALTER ROLE blogadmin SET default_transaction_isolation = 'read committed';

  - asign privileges 
  GRANT ALL PRIVILEGES ON DATABASE blog TO blogadmin;

  -Sortir du schell
  \q