Обсуждение: password encryption

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