Received: from mail.greatbasin.net (mail.greatbasin.net [207.228.35.39])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f4KLnYA80465
	for <pgsql-interfaces@postgresql.org>;
	Sun, 20 May 2001 17:49:35 -0400 (EDT)
	(envelope-from jeremy@wellsgaming.com)
Received: from [172.16.1.6] (rno-dsl0b-131.gbis.net [216.82.145.131])
	by mail.greatbasin.net (8.9.3-MySQL-0.2.3b/8.9.3) with ESMTP id
	OAA07955; Sun, 20 May 2001 14:49:25 -0700 (PDT)
User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.02.2022
Date: Sun, 20 May 2001 14:49:33 -0700
Subject: Re: Security
From: Jeremy Buchmann <jeremy@wellsgaming.com>
To: "Ernesto A. Lira Castro" <lira@ver.megared.net.mx>,
	<pgsql-interfaces@postgresql.org>
Message-ID: <B72D89FD.2DFA%jeremy@wellsgaming.com>
In-Reply-To: <3B06146E.7759BFD9@ver.megared.net.mx>
Mime-version: 1.0
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
X-Archive-Number: 200105/89
X-Sequence-Number: 1616

> I'm trying to set login & passwords to my system with Perl DBI for
> Postgresql, but i want to have a field on my Postgres's database
> that can be type password!! is that possible?? i see only fields types
> (Char, integer, long . . .) i want some password to be encrypted.

You can use MD5 or SHA perl modules to get a digest of the password and then
get the hex representation of the digest and store that in the database as a
char or varchar.

> And where can i get some information for implementing that security on
> my system!

The MD5 and SHA modules are on cpan.org.  I only have experience with the
MD5 module, but it's very simple to use, provided you know a little Perl.  I
can show you code if you don't understand the examples provided with the
module.

-- Jeremy  [jeremy@wellsgaming.com]