Need help on pgcrypto

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers