Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 45F66475A50
	for <pgsql-admin@postgresql.org>; Wed, 21 Aug 2002 20:33:55 -0400 (EDT)
Received: from linuxmail.lgsinc.com (unknown [12.22.4.163])
	by postgresql.org (Postfix) with ESMTP id BB1DF475DBA
	for <pgsql-admin@postgresql.org>; Wed, 21 Aug 2002 20:33:49 -0400 (EDT)
Received: from timetop ([10.13.15.254])
	by linuxmail.lgsinc.com (8.11.6/8.8.7) with SMTP id g7M0Y4U07826;
	Wed, 21 Aug 2002 17:34:04 -0700
Date: Wed, 21 Aug 2002 17:36:38 -0400
From: Tim Ellis <Tim.Ellis@gamet.com>
To: Stefan Fiel <fstefan@cable.vol.at>
Cc: pgsql-admin@postgresql.org
Subject: Re: password encryption
Message-Id: <20020821173638.4428eb90.Tim.Ellis@gamet.com>
In-Reply-To: <5.1.0.14.0.20020820115452.03ed0a28@mail.cable.vol.at>
References: <5.1.0.14.0.20020820115452.03ed0a28@mail.cable.vol.at>
Organization: Gamet
X-Mailer: Sylpheed version 0.7.4 (GTK+ 1.2.10; i586-mandrake-linux-gnu)
WerdupHomey: 3.14159265358979323
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/243
X-Sequence-Number: 5357

> i like to store passwords for a webapplication in my postgre database.
> 
> now i'm searching for a way to encrypt the passwords, something like the
> function password() for mysql.

I always run my passwords through md5sum(), which is an open source
implementation, and thus seems to've been written in every language out
there.

-- 
Tim Ellis
Senior Database Architect
Gamet, Inc.