connect to postgresql command line with user code example
Example 1: how to connect postgres user password using command line
sudo -u postgres psql postgres
Example 2: How do I add a user to a postgres database? cli
psql=# grant all privileges on database <dbname> to <username>