Use the md5 function:
select md5('welcome');
md5
----------------------------------
40be4e59b9a2a2b5dffb918c0e86b3d7
(1 row)
Regards,
Chris Smith
Suite 30, 45-51 Huntley St, Alexandria, NSW 2015 Australia
Ph: +61 2 9517 2505
Fx: +61 2 9517 1915
email: info@interspire.com
web: www.interspire.com
Jamie Deppeler wrote:
> Tino Wildenhain wrote:
>
>>Hi,
>>
>>Am Freitag, den 17.12.2004, 09:41 +1100 schrieb Jamie Deppeler:
>>
>>
>>>Hi,
>>>
>>>I was just wondering is it possible to encrypt a filed in the database
>>>with md5? i know it is possible to do it with DB users
>>>
>>>
>>
>>No. You cannot encrypt with md5 because you cant decrypt.
>>md5 is a hash function. But you can use it any time to
>>hash values you insert.
>>
>>Regards
>>Tino
>>
>>
>>
>>
>>
> Well basically i want to store and hashed value that will never be
> changed just compaired too hashed values
>
> also when i try to encrpyt a field i get this error
> encypt(text,"unknown","unknown")
>
>
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.296 / Virus Database: 265.5.4 - Release Date: 12/15/2004
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.4 - Release Date: 12/15/2004