Thread: Two way encription in PG???

Hi,

Im porting my software from mySQL to PG.
I need to encypt a field in a table using two way encription. In mySQL
for those purposes I was
using build-in functions ENCODE/DECODE, is there such an equivalent in
PG?
How do I encrypt/decrypt something in PG?


Regards,
Boulat

Boulat Khakimov writes:

> How do I encrypt/decrypt something in PG?

Download 7.1 and use the contrib/pgcrypto module.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

Peter Eisentraut wrote:

> Boulat Khakimov writes:
>
>> How do I encrypt/decrypt something in PG?
>
>
> Download 7.1 and use the contrib/pgcrypto module.
>
I looked at the pgcrypto README file and it seems that it only makes
one-way hashes. None of the functions had a key argument of any kind.
The encode/decode functions are for bin/ascii encoding/deconding, not
cryptographic. Any more info about this?

Thnaks,
   Jeff Davis

On Sun, Mar 04, 2001 at 10:37:10PM -0800, Jeff Davis wrote:
> Peter Eisentraut wrote:
> > Boulat Khakimov writes:
> >> How do I encrypt/decrypt something in PG?
> >
> > Download 7.1 and use the contrib/pgcrypto module.
> >
> I looked at the pgcrypto README file and it seems that it only makes
> one-way hashes. None of the functions had a key argument of any kind.
> The encode/decode functions are for bin/ascii encoding/deconding, not
> cryptographic. Any more info about this?
>

Yeah, I have.  I have source too...  I try to make Real Soon a
beta release, coz I have now mostly stable internal interfaces
worked out.  Real stable encrypting will still take some time,
coz I have found amazing amount of bugs, needed workarounds and
simply weirdnesses in different crypto libraries.  Only way to
make sure that a cipher produces right results is to test with
official test vectors.  Fun, fun...

--
marko