Обсуждение: MD5 encrypt

Hi,


Is there any function on postgresql that allows to encrypt data when
making an Insert statment?


Tks a lot,

Alvaro

On Wed, Dec 24, 2003 at 11:47:53AM -0500, alvaro@audifarma.com.co wrote:
>
> Is there any function on postgresql that allows to encrypt data when
> making an Insert statment?

What kind of encryption are you looking for?  MD5 is a one-way hash:
you can't decrypt the hash to get back the original plaintext.  If that's
what you need (e.g., for storing passwords), then you could use the md5()
function that's part of the the standard distribution since version 7.4.

http://www.postgresql.org/docs/current/static/functions-string.html

For older versions of PostgreSQL or for additional encryption functions,
see the code in contrib/pgcrypto.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/