manthan@manthan-HP-348-G3:~$ sudo -i -u postgres
postgres@manthan-HP-348-G3:~$ psql
psql (12.2 (Ubuntu 12.2-4), server 10.12 (Ubuntu 10.12-2.pgdg18.04+1))
Type "help" for help.
postgres=# create database portfolio;
CREATE DATABASE
postgres=# create user portfolio with password 'folio';
CREATE ROLE
postgres=# alter role portfolio set client_encoding to 'utf8';
ALTER ROLE
postgres=# alter role portfolio set default_transaction_isolation to 'read committed';
ALTER ROLE
postgres=# alter role portfolio set timezone to 'UTC';
ALTER ROLE
postgres=# grant all privileges on database portfolio to portfolio;
GRANT
postgres=#