Re: Encrypting fields with a one-way hash

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Alexi Margo <alexi(at)wwood(dot)co(dot)uk>
Cc: "'pgsql-general(at)PostgreSQL(dot)org'" <pgsql-general(at)PostgreSQL(dot)org>
Subject: Re: Encrypting fields with a one-way hash
Date: 2000-09-26 17:04:18
Message-ID: Pine.BSF.4.10.10009261002580.84227-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I don't believe there is an internal function for it, although it
would probably be an easy function to write in C and make available
with CREATE FUNCTION.

Stephan Szabo
sszabo(at)bigpanda(dot)com

On Tue, 26 Sep 2000, Alexi Margo wrote:

> Hi,
>
> I'm new to PostgreSQL, but have installed it on a RedHat 6.2 box. We are
> currently trying to migrate our existing MySQL applications to PostgreSQL,
> but the differences in syntax are presenting a few problems.
>
> My main stumbling block is the apparent lack of a function to form a hash
> (or other one-way encrypt) of a password to enter as a field in the
> database. The old SQL looks something like:
>
> > INSERT INTO Users (Name, Password) VALUES ('John Smith',
> PASSWORD('mypassword'))
>
> This works because "PASSWORD" is an internal function in MySQL. Is there a
> similar function in PostgreSQL, or some other way of achieving the same
> effect? The data itself is not being moved over, so there is no need for the
> same algorithm to be used.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2000-09-26 17:05:15 Re: problem creating template database
Previous Message Edward Q. Bridges 2000-09-26 16:50:38 Re: web programming