Re: Need help on pgcrypto

From: Vitaly Burovoy <vitaly(dot)burovoy(at)gmail(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: rajan <vgmonnet(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Need help on pgcrypto
Date: 2016-01-11 13:26:08
Message-ID: CAKOSWNk-+2M5opqErWj2dmsjknRTEJSPsiw2NxRgwfk_2x1Y5w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 1/11/16, Michael Paquier <michael(dot)paquier(at)gmail(dot)com> wrote:
> On Mon, Jan 11, 2016 at 10:03 PM, rajan <vgmonnet(at)gmail(dot)com> wrote:
>> Trying to find a documentation which will make me understand how to secure
>> a
>> password column. I want the encryption to be one way and it should not be
>> decrypted.
>>
>> I am able to find discrete documents but nothing of them gets me there.
>
> Er, isn't that enough?
> http://www.postgresql.org/docs/devel/static/pgcrypto.html
> --
> Michael

I'd give more specific URL with examples of SELECT and UPDATE:
http://www.postgresql.org/docs/devel/static/pgcrypto.html#AEN170716

... but recommend to change just "gen_salt('md5')" to "gen_salt('bf', 8))"

--
Best regards,
Vitaly Burovoy

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christian Bjørnbak 2016-01-11 13:29:00 Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102
Previous Message Peter Krauss 2016-01-11 13:18:06 Re: looking for an array-extract-item-as-it operator