password encryption

From: "Silesky Marketing Inc, Support" <support(at)silesky(dot)com>
To: "pgsql" <pgsql-sql(at)postgresql(dot)org>, "pggeneral" <pgsql-general(at)postgresql(dot)org>
Subject: password encryption
Date: 2000-07-21 16:08:10
Message-ID: 00d001bff32d$dd5b0170$8d742440@admin
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mjp 2000-07-21 17:03:07 Emulating "\d" Output
Previous Message DalTech - CTE 2000-07-21 15:06:27 Re: problem with view and case - please help

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-07-21 17:26:09 Re: Timestamp indexes
Previous Message Mitch Vincent 2000-07-21 15:53:25 Re: Timestamp indexes