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 e6LHM6h66286
	for <pgsql-admin@postgresql.org>; Fri, 21 Jul 2000 13:22:06 -0400 (EDT)
Received: from admin (admin [64.36.116.141])
	by omnet.wwcdesigns.com (8.9.3+Sun/8.9.1) with SMTP id NAA16559
	for <pgsql-admin@postgresql.org>; Fri, 21 Jul 2000 13:21:27 -0400 (EDT)
Message-ID: <00fe01bff337$d1b0f7d0$8d742440@admin>
From: "Silesky Marketing Inc, Support" <support@silesky.com>
To: "pgadmin" <pgsql-admin@postgresql.org>
Subject: password encryption
Date: Fri, 21 Jul 2000 13:19:25 -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/86

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