If the encrypt function is from the contribs, it CAN do reversible encryption, you just have to choose which encryption
typeyou want to use. Please look in the archives at:
http://marc.theaimsgroup.com/?l=postgresql-general&w=2&r=1&s=encrypt+contrib&q=b
Ivan wrote:
>>Ivan wrote:
>>
>>>hi
>>>
>>>i need to encrypt some fields in a table of my postgre db, my table is
>>>named clients and the fields are "id", "name" and "password", i was
>>>looking and i find the pgcrypto utility, i read something about the
>>>pgcrypto functions and i see the "crypto" function and use it, well
>>>the fields change and i supose that was encrypted... but how i could
>>>obtain the decrypt info??? (i don't know it), well next i read about
>>>the "encrypt-decrypt" function, maybe it is what i need i try to use
>>>the encrypt function from the EMS PostgreSQL Manager (SQL editor) in
>>>that form
>>>
>>>UPDATE tabla2 SET pass = encrypt(pass, 'iv', 'bf');
>>>
>>>next i try:
>>>
>>>encrypt(pass,'fooz','bf')
>>>
>>>but either work... i don't find much examples about it, pls does
>>>anyone have an idea of how i can implement the "encrypt-decrypt on my
>>>table???
>>
>>You may be running into a "one-way-hash" encryption system - in which
>>when you use the crypto function, the data is stored in encrypted
>>format, with the idea that you take your input supplied, encrypt it, and
>> compare it to the field (containing the previously encrypted data) - if
>> it matches, then the "password" or whatever was entered correctly.
>>
>>It typically isn't possible to reverse this one-way hash back to
>>plaintext easily.
>>
>>Andrew Ayers
>
>
>
> thanks Andrew. well now i know that the crypt function is not what i need,
> i need to encrypt all the fields of some tables not only the passwords, if
> someone knows how to use the encrypt/decrypt function and could tell me
> something, i will be grateful
>
> ivan
>
>
> --------------------------------------------
> Free Webmail courtesy of http://www.444.net/
>
>
> ---------------------------(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
>