Postgres Pro
Downloads
Home   >   mailing lists

Re: Encrypted role password - Mailing list pgadmin-support

From Melvin Davidson
Subject Re: Encrypted role password
Date
Msg-id 477703445.521194.1506695636541@mail.yahoo.com
Whole thread Raw
In response to Encrypted role password  (Mark Watson <mark.watson@jurisconcept.ca>)
Responses RE: Encrypted role password
List pgadmin-support
Tree view
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';





Melvin Davidson 🎸
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com



On Friday, September 29, 2017, 10:21:58 AM EDT, Mark Watson <mark.watson@jurisconcept.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

 

pgadmin-support by date:

Previous
From: Mark Watson
Date:
Subject: Encrypted role password
Next
From: Mark Watson
Date:
Subject: RE: Encrypted role password