Re: MD5 Passwords and user administratio - Mailing list pgsql-admin

Carlos Ortiz <ortizc2@yahoo.com> writes:
> I am trying to figure out exactly how to set someone's password when
> using MD5 passwords in postgres.

ALTER USER joe WITH PASSWORD 'secret';

> What exactly is psotgres passing to the MD5 hash to make up that
> incredible unintelligible stream of characters that it stores in the
> password field of the pg_shadow table?

I think the salt is the username --- but you shouldn't write code that
depends on knowing that.  None of the MD5 behavior is considered
user-visible.

            regards, tom lane