From: | "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu> |
---|---|
To: | geniusj(at)bluenugget(dot)net |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PASSWORD() function for postgresql? |
Date: | 2001-07-16 15:59:47 |
Message-ID: | Pine.LNX.4.21.0107161150340.9097-100000@aluminum.cs.pitt.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I don't recal finding anything similar to MySQL's password() (quote handy if you ask me). But if you look under the contrib directory of your source tree you'll find a pgcrypto directory. Compile and install the functions defined in there.
The substitute which worked in my case was: encode(digest('text_i_want_to_encode','sha1'),'hex'); It is not the same but it is a 1-way hashing of a string (IIRC password() is 1-way)
cheers,
thalis
On Sun, 15 Jul 2001 geniusj(at)bluenugget(dot)net wrote:
> I am looking for a postgresql PASSWORD() function that
> produces hashes compatible with MySQL's implementation.
>
> I am converting from MySQL and I know of no other way to
> use the passwords I have in the old database other than
> having a compatible PASSWORD() function.
>
> I have searched around for one quite a bit but could not find
> one. Does anyone know if someone has written something
> to do this already? If so, where I can get it from?
>
> Thanks in advance,
> Jason DiCioccio
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-07-16 16:02:09 | Re: slow line insert |
Previous Message | Bruce Momjian | 2001-07-16 15:56:58 | Auguest Linux Journal |