Re: encrypt/decrypt problem - Mailing list pgsql-general

keep reading, it takes a while to understand that library. Plus, you have to have it installed in your postgres
installation.Apparently you do, since you were able to do 'encrypt'. 

however, your arguments don't look right, which is why I suggest continued reading.

Ivan wrote:
> thanx for the link!! it have cool info, well i learn how to use the
> encrypt function:
>
> UPDATE tabla2 SET lastname = encrypt('pass', 'pass', 'bf') where apellido
> = 'noriega';
>
> with that i change the fields  i need to be encrypted... but there is
> another problem... how i can obtain the decrypted data??, i suppose that i
> need to use the "decrypt" function, i was trying to use it in that way:
>
> SELECT decrypt('lastname', 'pass', 'bf') as "worked" from tabla2 where
> apellido = 'noriega';
>
> but i only obtain an encrypted value (different that the i already had in
> the db)... anyone knows how to obtain the decrypted data???
>
> ivan
>
>
>
>
>>If the encrypt function is from the contribs, it CAN do reversible
>>encryption, you just have to choose which encryption type you 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
>>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>>http://www.postgresql.org/docs/faqs/FAQ.html
>
>
>
>
> --------------------------------------------
> Free Webmail courtesy of http://www.444.net/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>