Re: [GENERAL] PASSWORD vs. md5('somepass')

Thanks, I was here . Am 20.03.2012 um 16:55 schrieb Josh Kupershmidt: > On Tue, Mar 20, 2012 at 8:28 AM, Alexander Reichstadt wrote: >> Hi, >> >> I look for a way to reproduce the encrypted string stored as a password by >> means

Re: [GENERAL] PASSWORD vs. md5('somepass')

On Tue, Mar 20, 2012 at 8:28 AM, Alexander Reichstadt wrote: > Hi, > > I look for a way to reproduce the encrypted string stored as a password by > means other than using the CREATE ROLE command. > > When using CREATE ROLEPASSWORD 'somepass' the resulting string for > rolpassword in pg_a

[GENERAL] PASSWORD vs. md5('somepass')

Hi, I look for a way to reproduce the encrypted string stored as a password by means other than using the CREATE ROLE command. When using CREATE ROLEPASSWORD 'somepass' the resulting string for rolpassword in pg_authid always starts with md5, suggesting it would create some md5 string.