set password to an user form psql code example
Example 1: how to connect postgres user password using command line
sudo -u postgres psql postgres
Example 2: how to connect postgres user password using command line
\password postgres
sudo -u postgres psql postgres
\password postgres