RE: Encrypted role password

De : Melvin Davidson [mailto:melvin6925(at)yahoo(dot)com]

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 :)

On Friday, September 29, 2017, 10:21:58 AM EDT, Mark Watson <mark(dot)watson(at)jurisconcept(dot)ca<mailto:mark(dot)watson(at)jurisconcept(dot)ca>> wrote:

Good day all,

First of all, thank you for the good work with pgAdmin4.

My question is, in pgAdmin3, the SQL pane for the role create script shows the md5 encrypted password. Are there any plans to display this for pgAdmin4 ?

Mark Watson