I used to have a user, say 'jack' in postgresql, and then I forgot what the password. I reassigned all its ownerships to user postgres, removed the user, and then created it again with
CREATE USER jack;.
Now if I try to connect with it, psql asks for a password.
$ psql db_name jack
Password for user jack:
psql: fe_sendauth: no password supplied
What is going on and how do I check if a user has a password or not?