psql connect to database with user and password 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