[SQL] create user xxx with md5 string?

Hi all. Im triyng, with no success, to create a user, and set the password with a md5 string. I did this: comechingon:~ # echo -n 123 | md5sum 202cb962ac59075b964b07152d234b70 - Ok, so then test=# CREATE USER foobar ENCRYPTED PASSWORD 'md5202cb962ac59075b964b07152d234b70'; --I have to add

Re: [SQL] create user xxx with md5 string?

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.

Re: [SQL] create user xxx with md5 string?

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

Re: [SQL] create user xxx with md5 string?

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

Re: [SQL] create user xxx with md5 string?

Tom Lane wrote: 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