Skip site navigation (1) Skip section navigation (2)

Re: encrypt/decrypt problem

From: "Ivan" <perseus(at)444(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: encrypt/decrypt problem
Date: 2003-04-29 17:38:27
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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???


> 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:
> Ivan wrote:
>>>Ivan wrote:
>>>>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:
>>>>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
>> ---------------------------(end of
>> broadcast)--------------------------- TIP 3: if posting/reading
>> through Usenet, please send an appropriate subscribe-nomail command to
>> majordomo(at)postgresql(dot)org so that your message can get through to the
>> mailing list cleanly
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?

Free Webmail courtesy of

In response to


pgsql-general by date

Next:From: Dennis GearonDate: 2003-04-29 18:00:57
Subject: Re: encrypt/decrypt problem
Previous:From: Robert TreatDate: 2003-04-29 17:33:49
Subject: Re: Inheritence woes

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group