I think what he was looking for was more along the lines of a generic sql
function that hashes a string, and not to update the system tables.
I actually wrote a replacement for the mysql PASSWORD() function that is
actually compatible with the hashing that mysql uses. If you would like a
copy of
On Fri, 21 Jul 2000, Silesky Marketing Inc, Support wrote:
> Hello,
>
> I want to encrypt passwords with Postgresql the way mySQL does it with :
>
> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
Check out the ALTER command.
ALTER USER username
[ WITH PASSWORD 'passw
Hello,
I want to encrypt passwords with Postgresql the way mySQL does it with :
UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
How can I do that ?
Thanks a lot,
Laurent
