Forum: Postgresql password generator project launched

Posted by: Enrico Pirozzi
Date: 2007-03-02 17:32
Summary:Postgresql password generator project launched

passgen is a pseudo-random password generator for PostgreSQL.It returns a text type and it can be useful to create a new user and assign to him a new random password.

Sponsors Ads

Latest News

Monitor Forum | Start New Thread Start New Thread
RE: alternative method [ reply ]
By: Enrico Pirozzi on 2007-05-09 08:54
Ok, it works,
but I think that is less fast than passgen, because you call many more postgresql functions to calculate it.


alternative method [ reply ]
By: Floris Sluiter on 2007-04-24 20:28
I usually use this to create a password consisting of base64 characters (a-zA-Z+/):

select passgen from (select substring(encode(decode(md5(random()::text),'hex'),'base64') from 1 for 8) as passgen ) t

No need for a special library or function

Powered By FusionForge