Received: from omnet.wwcdesigns.com (node-40247483.powerinter.net [64.36.116.131] (may be forged)) by hub.org (8.10.1/8.10.1) with ESMTP id e6LGAph47249; Fri, 21 Jul 2000 12:10:51 -0400 (EDT) Received: from admin (admin [64.36.116.141]) by omnet.wwcdesigns.com (8.9.3+Sun/8.9.1) with SMTP id MAA16197; Fri, 21 Jul 2000 12:10:11 -0400 (EDT) Message-ID: <00d001bff32d$dd5b0170$8d742440@admin> From: "Silesky Marketing Inc, Support" To: "pgsql" , "pggeneral" Subject: password encryption Date: Fri, 21 Jul 2000 12:08:10 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200007/782 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