(Ignore my other reply.. ;P)
You'll need to import the pgcrypto.sql file (this creates the functions
for you).
Read the doco on how to install the extension, it should tell you where
the sql file is.
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