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

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/