Re: Data Encryption in PostgreSQL, and a Tutorial.

[Dias Bantekas <dbadekas@aia.gr>]

btober@computer.org wrote:
> > Dias Bantekas wrote:
> >
> >
> > > does any one know how to get an md5()-like hash function using
> > > pgcrypto for postgresql 7.3 ? without upgrading to 7.4
> > >
> > > Thanks for any input.
> >
> > SELECT encode(digest(v_password, 'md5'), 'hex');
>
>
> BTW,
>
> /usr/share/pgsql/contrib/pgcrypto.sql
>
> is the script that defines the encode and digest functions.
>
> --Berend Tober

thanks hlk, that's exactly what I was looking for.
Now I can create a md5() function and do my job!

encode is a native PG string function, it is not defined in pgcrypto.


Dias


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to majordomo@postgresql.org so that your
     message can get through to the mailing list cleanly