Check if a role in PostgreSQL has a password set

Passwords are stored in pg_shadow

In documentation:

Password (possibly encrypted); null if none. See pg_authid for details
of how encrypted passwords are stored.

So you should select * from pg_shadow;

You should also check pg_authid table.