Carlos Ortiz <ortizc2(at)yahoo(dot)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