Re: unable to find function to encrypt text using 3des algorithm with 3 independent keys - Mailing list pgsql-general

From Chris Travers
Subject Re: unable to find function to encrypt text using 3des algorithm with 3 independent keys
Date
Msg-id CAKt_Zfty=p-hc9ibC0Bt3Ur30N6NGJNfo=HF=0dFpZu8EuaEeQ@mail.gmail.com
Whole thread Raw
In response to unable to find function to encrypt text using 3des algorithm with 3 independent keys  (vijay bikas <vijay.bikas@gmail.com>)
List pgsql-general
On Mon, Jul 25, 2011 at 2:58 AM, vijay bikas <vijay.bikas@gmail.com> wrote:
> dear !
>
> I have a project in which we want to encrypt and decrypt data using 3des
> algorithm using 3 independent keys .
> I am unable to find the inbuilt  function in postgres to encrypt and decrypt
> data using 3des with 3 independent keys.
>
> Pls guide me .

Look into pg-crypto:

http://www.postgresql.org/docs/8.3/static/pgcrypto.html
(just the first version that popped up for me, but the contrib module
is supported on all other versions currently supported)

Best Wishes,
Chris travers

>
> Thanks !
> Vijay Bikas
> Soft. Engineer.
> NSPL, Mumbai
>

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: Disallow access from psql, or allow access only from specific client app
Next
From: "Markus Wollny"
Date:
Subject: Re: Query, usually running <300ms, sometimes hangs for hours