Re: MySQL password function

From: "Roderick A(dot) Anderson" <raanders(at)acm(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: MySQL password function
Date: 2002-07-10 21:59:38
Message-ID: Pine.LNX.4.33.0207101456070.24282-100000@main.cyber-office.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 10 Jul 2002, Neil Conway wrote:

> On Wed, Jul 10, 2002 at 12:58:09PM -0700, Roderick A. Anderson wrote:
> > The insert statement has one value of "password('foo')." Since the app
> > was designed for MySQL I'm sure I'll run into this later so I need to
> > figure out the PgSQL way or a workaround.
>
> I believe contrib/pgcrypto will do this for you (and give you a bunch
> of digest algorithms to choose from).

Neil, Philip,

Thanks for the ideas. When I read Phillip's I thought "Oh Great" 'cause I
stay as far away from MySQL as I can. Then I read Neil's reply and
slapped my forehead and said doh!

Again thanks,
Rod
--
"Open Source Software - Sometimes you get more than you paid for..."

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Agent155 Support 2002-07-10 22:00:03 workaround for lack of REPLACE() function
Previous Message Michael Adler 2002-07-10 21:30:34 pgrypto.so load error (was: hash(text) function inside db?)