RE: Encrypted role password - Mailing list pgadmin-support

I am not pgadmin support, but if you are a superuser,

you can get the password with:

SELECT rolname,
       rolpassword
  FROM pg_authid
WHERE rolname = 'username';

-----------------------------------

Thanks, Melvin

It’s also available in pg_shadow. I was just having a lazy day :)