On 1/11/16, Michael Paquier <michael.paquier@gmail.com> wrote:
> On Mon, Jan 11, 2016 at 10:03 PM, rajan <vgmonnet@gmail.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