Thread

1. Two way encription in PG???

   Boulat Khakimov <boulat@inet-interactif.com> — 2001-03-04T17:08:49Z

   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
   
   
   

2. Re: Two way encription in PG???

   Peter Eisentraut <peter_e@gmx.net> — 2001-03-04T18:17:57Z

   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/
   
   
   

3. Re: Two way encription in PG???

   Jeff Davis <jdavis@dynworks.com> — 2001-03-05T06:37:10Z

   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
   
   
   

4. Re: Two way encription in PG???

   Marko Kreen <marko@l-t.ee> — 2001-03-05T20:03:55Z

   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