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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED]
>
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
