On 1/11/16, Michael Paquier <michael.paqu...@gmail.com> wrote: > On Mon, Jan 11, 2016 at 10:03 PM, rajan <vgmon...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers