Edmund wrote:
jd@xxxxxxxxxxxxxxxxx ("Joshua D. Drake") writes:
Fernando Lujan wrote:
Hi folks,
I have a table wich contains my users... I want to insert to each
user
a random password, so I need a random function. Is there such function
in Postgres? I just found the RANDOM which generates values between
0.0 and 1.0.
Any help or suggestion will be appreciated. :)
I would do someting like:
select substring(md5(random() || random()), 5, 8);
Sincerely,
Joshua D. Drkae
Great! a simple, dumb program can generate all your passwords in very
quickly. My 2.4 Ghz Pentium 4 did it in under 10 minutes. A token set of
16 characters, and a fixed length of 8 charachters just isnt a very big
search space.
This is why I suggested a variable-length random string function. But
this not as trivial to impliment.
Best Wishes,
Chris Travers
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
