Sorry for my prev post. I mean md5(password || username). 'test10' is a username on which i checked. :) Sorry!
2009/12/3 Dmitriy Igrishin <dmit...@gmail.com> > Hello all. > Tom right. Encrypted MD5 passwords computed as md5(password || test10). I > checked. > > Regards, Dmitriy Igrishin. > > 2009/12/3 Tom Lane <t...@sss.pgh.pa.us> > > Gerardo Herzig <gher...@fmed.uba.ar> writes: >> > Hi all. Im triyng, with no success, to create a user, and set the >> > password with a md5 string. >> >> The correct method for computing the md5'd password includes the >> username. I think it's 'md5' || md5sum(password || username) >> but look at the code or docs. >> >> regards, tom lane >> >> -- >> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-sql >> > >