Thread: Need help on pgcrypto
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. Please help. ----- -- Thanks, Rajan. -- View this message in context: http://postgresql.nabble.com/Need-help-on-pgcrypto-tp5881477.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
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
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