Re: Manually authenticating users in pg_shadow - Mailing list pgsql-general

"William Harazim" <wharazim@fulcoinc.com> writes:
> Ahh, the password || username format of the stored password was the problem. Incidentally, for anyone else not having
themd5() function (is that new to 7.5dev?) I was able to accomplish the same thing using  
>    'md5' || encode( digest(password || username, 'md5'), 'hex' )

md5() is in 7.4, but I think it's new in that release.

            regards, tom lane